Summing RG's total of dynamic values


I have a RG that displays list of products. I have data fields that store the values of each item’s q’ty and unit price, but I don’t want to store the amount because I need to leave it dynamic so that unit price of an item is changed somewhere else, I want it to be reflected dynamically.

The problem I am seeking an answer for is if there is a way that I can calculate the total of each item’s amount (q’ty x u/price) when the amount value is not stored in the database and it remains dynamic.

Any help would be highly appreciated.


You can simply put the expression like “Current cell’s qty*Current cell’s unit price”.

You can check the solution here