PREVIOUSVERSION(Data) not showing prior forecast actual data - please help!
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!