Calculation Logic across Time dimension

Options
NilanjanDutta
NilanjanDutta Member, ALL USERS, Certified Model Builder Posts: 5 Contributor
in Planning & 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:

Comments

  • nathan_rudman
    nathan_rudman Member, ALL USERS, Master Anaplanner - Employee, Employee, Certified Model Builder Posts: 5 Master Anaplanner of the Year

    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 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    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