Forum Discussion
Running Total dependency based on previous date
Hi all, I have the below data - first 3 columns ( date & move & open) the rule open balance - 180,000 the max amount is 800,000 the min amount is 150,000 the blue columns are for explanation...
nirrobi , When I paste these number s on excel. I am not geting 405 , 64 and 110 as separate number.
|
Date |
Movement | Open | Expected Result | Logic |
| 202101 | -405451 | 180000 | 180000 | |
| 202102 | -64036 | 150000 | 180-405=-225 < 150 --> 150 | |
| 202103 | 237137 | 150000 | 150-64=85<150 -->150 | |
| 202104 | 110441 | 387137 | 150+237=387>150 & 387<800 -->387 | |
| 202005 | 500000 | 800000 | 387+500=887>800 -->800 |
Can you provide better sample
thanks for your reply
the 405 should read 405 K = 405000 = 180000-405451=-225451