Need help for the logical formula of having a running balance

henris0n
henris0n
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.

 

henris0n_0-1671080998921.png

 

Thank you!

Tagged:

Best Answer

  • pyrypeura
    pyrypeura
    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,

    Pyry

Categories