I have a read-only grid that displays data retrieved using the record data function. The data appears as expected. However, I need to calculate the Total Amount based on the "Amount" column in the grid, and this total should be displayed outside the grid in another card layout.
The issue is that using the record data function, I'm unable to access the data in a separate local variable to calculate the Total Amount. Although I can use the query record type function to obtain the data and calculate the total amount, this approach is not considered best practice.
How can I calculate the Total Amount while using the record data function?
Please Give me any Solution for this
Discussion posts and replies are publicly visible
i think you can still have local variable that will be just sum of index of property. Try this Sum(index(yourecordtype, recordtype.fileds.fieldname)).
I would avoid query db again as this may have negative impact on page performance.
Hi Furman ,I have tried but the data is coming in grid by using Record data,so I need to take sum from amount which is in grid