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
laxmipavanik0001 said: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.
According to whom?
Hi Mike Schmitt ,If we have a large amount of data in record type (over 5000 rows), querying the record type will fetch all the data into the interface, which will impact performance.
In your case, the custom grid seems to be the only option to use the same data reference at multiple places.