Hi, I am looking to create replicate the table of calculations in Outsystems as seen in the attached. However, I do not know how to do this quickly and easily. Really appreciate the help and advice here.
Hi Angeline,
You can use 2 table to show calculation on the basis of values display in above column. To achieve this you can follow below steps:
1. Create another table just below your previous one
2. Perform calculation when you fetch data from aggregate(If you are manipulating the data during run time then use refresh data) i.e. perform calculation just after you get data from aggregate.
3. Inside your new table use expression and assign that value.
Hope this will help you
Regards,
Vipasha Sharma
Hello Angeline,
In addition to Vipasha's suggestion, try to use as well the Group by and Sum function within the aggregate.
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Aggregate_a_Column_into_a_Single_Value
Hope this helps.
Kind regards,
Chris
Thank you everyone for your quick response. Really appreciate your expertise. I will give it a try and if I am stucked, will ask for help again cos I am really an amateur still learning this tool.