Need help for the logical formula of having a running balance

edited December 2022 in Modeling

So basically I need help in the formula for arriving in the 'Final' line item. I tried using Previous formula but I am missing something in the logic.




Thank you!

Best Answer

  • Hi,


    You could use formula like "IF input<>0 THEN Input ELSE PREVIOUS(Final)" Then you would have value from input line item if the value differs from 0 and if input equals 0 then previous month value is used.


    Best regards,