I have list of transaction raw data field namely amount, i need to calculate closing value from this amount field For each day, Closing value formula is opening Amount + all transaction Amount = closing Amount
My query is how to write expression to get closing value
i have fields
Amount
Trx_Date
Select_date (Input parameter)
raw data
Example jan 1st closing is 453.15 Feb 2nd closing is 453.15+157.73 = 610.87, I just show you the raw data, between 1 jan to 2nd feb no data if i select
feb 2 need to show 610.87 then if i select 7th apr need to show 57.75
