YoY Change % to forecast a line item from actuals

visivasa

Assume, I have the following line items using which I am trying to build a prediction/forecast for "Revenue". 

 

Revenue --> Actuals are imported for the actuals period, and this should be the forecast for the forecast period.

YoY Chg% --> Imported input data that tells the % change in Revenue YoY for that month, for the forecast period alone.

TimeControl Module.IsActuals ---> My system time control module's line item called "IsActuals" is a 1 or 0 flag, that tells whether a particular month is 1 for "actuals" or 0 for "forecast" and is calculated based on the time switchover setting. 

TimeControl.PreviousYear --> System time control line item called "PreviousYear" that gives the exact date 1 year prior to START(). 

 

I want the Revenue line item to behave as follows:

 

Revenue = IF TimeControl.IsActuals = 1 THEN <Do nothing> ELSE Revenue[LOOKUP: TimeControl.PreviousYear] * ( 1 + YoY Chg%) 

 

For the do nothing time period, I would want to be able to import the Actuals. 

 

How do I achieve the above? I have traditionally done this by using anotehr line item called "Revenue Actuals" where I upload the actuals, and the Revenue (Forecast) will be Revenue = IF Revenue Actuals <> 0 THEN Revenue Actuals ELSE Revenue Actuals[LOOKUP: TimeControl.PreviousYear] * (1 + YoY Chg%).

 

I am looking for advice on what is the best way to achieve the above, and if it is possible to do using one line item for Revenue instead of using another Revenue Actuals line. 

 

 

visivasa

@usman.zia -- Thanks for your response! 

For several modeling reasons, certain modules and line items are not leveraging the Anaplan native versioning as it does not serve our internal purposes. The example I gave you was not for Revenue but something else actually - I just called it Revenue for discussion purposes.  I agree that for Revenue or something as straight-forward as YoY Change that it does makes sense to use the internal versioning.