Hello.
I'd like to display the calculated total values of the numbers in the same row, to the right of the column.
Currently, there are 5 NumberColumn widgets, and each of them has values.
I thought I could use the CalculatedColumn widget, however, it only accepts Formula data type or TextList data type. I use a DataAction to display the DataGrid, so I created the TextList output parameter and appended the total values of each row in Aggregate to it. Then I bound that TextList to the CalculatedColumn widget, but nothing was displayed.
I also created a new column to calculate the total valuesin Aggregate but it resulted in an error.
How can I use the CalculatedColumn widget, or are there any alternative solutions?
Thanks.
Hi @Yuika Maeda, please refer to Column with formula documentation, I have updated your OML according to this. Please check if it works.
ThanksGitansh Anand
Hello Gitansh,
It worked! I appreciate you.
I couldnt attach oml file cause the files I attached were too large, so here's my oml.
Hi Yuika Maeda,Please refer this link,https://www.outsystems.com/forums/discussion/74465/outsystems-data-grid-possible-to-show-aggregation-in-a-total-row/
you need to create separate aggregate to calculate the total count and then use it in the grid.