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