Calculation Logic across Time dimension

nildutta
Contributor

Calculation Logic across Time dimension

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

2 REPLIES 2
nathan_rudman
Master Anaplanner/Community Boss

Re: Calculation Logic across Time dimension

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


Nathan Rudman, Anaplan Model Builder
dgingras
Contributor

Re: Calculation Logic across Time dimension

I think this should do it for you:

 

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