Calculation Logic across Time dimension

NilanjanDutta_*20530
NilanjanDutta_*20530
in Modeling

Hi,

I am trying to achieve the following output in Final Value line item. 

1) Till the first override the system should take the Value line

2) Once Override is checked, the system should take the override value and copy it across the remaining timeline unless a new override is done 

 

nildutta_0-1623074736831.png

Can someone please help in defining the logic for the final value line item?

 

Thanks,

Nilanjan

Tagged:

Answers

  • nathan_rudman
    nathan_rudman

    you can "push forward" the boolean with a formula on a line item called Override Final:

    IF Override then override esle previous(Override Final)

     

    Then your final value is just referencing Final Override

  • dgingras
    dgingras

    I think this should do it for you:

     

    IF Override THEN Override Value ELSE IF MONTH(START()) = 1 THEN Value ELSE PREVIOUS(Final Value)

     

     

Categories