2023 Mar 30 8:22 AM - edited 2023 Apr 14 8:11 AM
This post is part of the SAP Build Community Challenge (April 2023)
This week’s challenge involves formulas – a key feature of SAP Build Apps. Formulas are used in bindings of components, and enable you to manipulate data before it is displayed in a component or before it is sent to a data source.
Formulas are created in the formula editor, which provides some tools for making writing formulas easier:
Here are some learning materials about formulas:
We will give you an app that looks like this (I like cats).
To set up the challenge, do the following:
You should now have the skeleton project.
Inside the app, we have already created a page variable called StartValue that contains the starting data that we want you to transform.
When you are ready, on the UI Canvas, select the Transform button, open the logic canvas, then select the Set page variable flow function, and finally go to set the formula for Assigned Value on the right (which currently returns an empty list).
This is what you need to do:
Your screenshot should look something like this but without the blur (I need to see the names and averages) and with your name:
Good luck ... and have fun!!
You have to do 3 things in the formula (aggregate/group, sort, round), so find a function that does each one. Use the wonderful editor features that document the available functions.
For example, for aggregating, go to the List area, and then find a function that aggregates (in this case, GROUP). You'll see all the documentation for it on the right, plus a little playground inside the documentation for testing it. Pretty cool!
2023 Apr 04 2:55 PM
2023 Apr 04 2:56 PM
2023 Apr 04 2:57 PM
2023 Apr 04 3:00 PM - edited 2023 Apr 04 3:01 PM
2023 Apr 04 3:17 PM
Hi Dan,
Movie: Madagascar
Great challenge! First time on SAP Build and I enjoyed it playing with Formulas.
2023 Apr 04 3:39 PM - edited 2023 Apr 04 3:40 PM
2023 Apr 04 3:49 PM
2023 Apr 04 5:04 PM
2023 Apr 04 7:07 PM
2023 Apr 09 11:22 AM
2023 Apr 05 4:34 PM
2023 Apr 05 6:30 PM
2023 Apr 06 3:33 PM
2023 Apr 09 10:30 AM
2023 Apr 07 12:23 AM
Challenge was accepted and completed! Looking forward to the next challenge.
Thanks,
2023 Apr 07 9:27 AM
Hi @Dan_Wroblewski ,
Thanks for that Challenge!!
Here is my screen shot form web and Mobile App
I really don't know the movie name...just got to know from the comments.
2023 Apr 09 10:31 AM
2023 Apr 12 1:13 PM
2023 Apr 07 12:40 PM
Thanks for the challenge. I learnt something new. 🙂
movie_Name: ["Madagascar 1", "Madagascar 2", "Madagascar 3"]
movie_Name[0]: "Madagascar 1"
Note; consider including "the Self Proclaimed Illustrious King in your test data. His Royal Highness King Julien.😃
2023 Apr 09 10:14 AM
2023 Apr 07 1:45 PM - edited 2023 Apr 08 5:04 AM
2023 Apr 07 3:22 PM
2023 Apr 07 8:35 PM
2023 Apr 09 9:56 AM
2023 Apr 08 2:50 AM
2023 Apr 08 1:18 PM
2023 Apr 08 1:49 PM
2023 Apr 08 6:18 PM
2023 Apr 09 9:53 AM
2023 Apr 08 11:45 PM
2023 Apr 09 9:51 AM
2023 Apr 09 10:32 AM
2023 Apr 09 3:11 AM
Hi, thanks for the opportunity and better late than never!!!
Movie: Madagascar
See you in the next one!!!
2023 Apr 09 9:43 AM
2023 Apr 09 10:00 PM
2023 Apr 10 12:49 PM
2023 Apr 10 1:24 PM
2023 Apr 10 3:11 PM
2023 Apr 10 4:47 PM
Hi Dan, great challenge!
Movie: Madagascar 😉
Thank you! Looking forward for the next one!
2023 Apr 11 11:38 AM
Glad you participated.
Second one already out 😺
https://blogs.sap.com/2023/03/30/you-think-you-know-sap-build-take-our-challenge/
😺