Posted: 11 Aug 2017 5:10 EDT Last activity: 9 Mar 2018 10:32 EST
How to calculate particular column values in a table grid and display it at the end of the column ?
Suppose the particular column is Asset price and it has values 1000, 2000, 3000 and at the end i have to calculate 1000+2000+3000 = 6000 which has to be displayed. I am getting the Asset details; Asset Number, Asset Name, Asset Description and Asset Price through an auto populated property say Asset Number by pressing down arrow button in the keyboard. At first i am selecting Asset number 0001 and display it in the table grid, the second time i am selecting Asset Number 002, which will appended into the second row in the repeating grid and so on. I am adding the screen shots of the flow into this post. Kindly assist.
I think the good approach will be to create a summary property and write a Declare Expression for it to sum the Asset Prices of all selected asset. Display that property in your section and add a refresh when on the dynamic layout where the summation property is added.
Thanks for the response. Hope you have seen the screens shots and the Data Transformation which i have used. Is the approach right way ? and I have used value list for appending the selected assets into table grid.