Dear all
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
how to write expression to get closing ???
Date Amount Closing
| 1-Jan-12 | 453.15 | 453.15 |
2-Feb-13 | 157.73 | 610.87 |
3-mar-13 | -6.14 | 604.74 |
| 4-apr-13 | 12.87 | 617.61 |
| 5-apr-13 | -169.68 | 447.93 |
| 6-apr-13 | -34.16 | 413.78 |
| 7-apr-13 | -356.03 | 57.75 |
| 8-apr-13 | -282.44 | -224.70 |
| 9-apr-13 | -18.45 | -243.14 |
| 10-apr-13 | -204.31 | -447.46 |
| 11-apr-13 | 272.18 | -175.28 |
| 12-apr-13 | 130.99 | -44.29 |
| 13-apr-13 | 311.19 | 266.90 |
| 14-apr-13 | 112.55 | 379.45 |
.png "Luminary Alumni"){kind=icon}