Forum Discussion

nirrobi's avatar
nirrobi
Icon for Helper V rankHelper V
5 years ago

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...
Need Help
nirrobi's avatar
nirrobi
Icon for Helper V rankHelper V
5 years ago

many thanks for your help!! much much appriciated!

 

in the file you sent it seems to work correctly.

I add few more lines to the row data but in 202110 the result is not correct - should be 250000 (1500000+100000)

 

 

nirrobi's avatar
nirrobi
Icon for Helper V rankHelper V
5 years ago

also 202109 is not correct - shoud be 800000 (800000+100000>800000 --> 800000)