Summing RG's total of dynamic values

Hi,

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.

Thanks

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

You can check the solution here