Hi,
I'm trying to "auto" calculate the total of a order.
Example:
Barbecue Pizza = 10€
Coca-Cola = 5€
What I have to do so this auto-calculate the Total of the order?
Ps: I have 2 diferent aggregates for Pizzas and Drinks, in which, both of them has diferent prices for the diferent "objects".
Thanks.
Hi Guilherme,
On your aggregate, you can click on the arrow on the top right corner of your attribute and get the sum off all the records for that attribute.
If you have two aggregates, you would have to do this for both and then sum those values, like this:
Let me know if this helps,
Pedro
You can also create new attributes where you can add your own logic. In this case, I'm calculating the Price * Quantity to get the Total Price of an order.
Let me know if this helps.
Check if this helps.
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Create_a_Calculated_Attribute_in_an_Aggregate?_gl=1*5l8voo*_ga*Mjg1MjkwMDAzLjE2MTAzOTA4OTc.*_ga_ZD4DTMHWR2*MTYxMjAzMzIzMC40MS4xLjE2MTIwMzU2MDEuNTA.
KR,
Ivan
You can't auto-calculate the value across different aggerate. You have to do that manually by adding some code.
Can you consider combining two aggregates into one? I think it's not difficult.
Kind Regards
I think you are right. If its the same order, why not use 1 aggregate and if you want to display them in separate tables, then use the listfilter.
As for the sum, i think this is easy: if the aggregate gives few records then just loop throught them to get the total. If there are many records, perhaps its best tu create another aggregate with a group by and use the sum.
@Pedro Marques Thank you! Worked just fine!
Glad it worked!