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...
Thank you so much!!!!!!!!
I amended 210107 to -700000
pls note 210109 - should be 150'000 - 100000-100000 <150000 --> 150000
also 210110 is not correct
Hi nirrobi ,
Sorry,I dont think there is a suitable measure to fit different values based on such criteria,as the result has always been checked.Even I give a measure for this set of movements,it may return errors in another set of movements,as the results will be reset for many times,which cant be determined.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!