Question
HCL TECHNOLOGIES LTD
IN
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.
BUPA
AU
Anurag,
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.
HCL TECHNOLOGIES LTD
IN
Hi Swarnendu,
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.