PREVIOUSVERSION(Data) not showing prior forecast actual data - please help!

Options
rtrigueros
rtrigueros Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Anaplanners - I am using PREVIOUSVERSION(Data) to pull the previous forecast's data (formula in first pic).   It's not pulling actuals before the current month  I.t seems to be working fine prospectively for future months and pulling in the previous forecast's values for future months.

 

I tried the following formula but to no avail:  IF PREVIOUSVERSION(DATA) = 0 THEN Data[SELECT: VERSIONS.Actuals] in the attempt to pull the actuals if the PREVIOUSVERSION(Data) did not produce values.

 

I am totally stuck here and would appreciate any direction from your previous experience;   I really appreciate it!

 

Ricardo

 

 

 

Tagged:

Categories