Take value from another version when value = 0

yoskaneko

Dear experts,

 

I have 3 versions(Actual, Forecast, Plan).

Then, since forecast have only short term such as 1 or 2 months,

I'd like to copy value from plan data into forecast data, if forecast data is 0.

 

Image of formula:

IF Versions = Forecast and Value=0 THEN Value[Select:Versions.Plan] ELSE Value

 

Could you give any suggestion?

 

Yoshi

 

 

Ansar.Sayfin

Hello,

It looks simple:

1) Create new 'Versions' Module' (dimension is versions only) with boolean line item named 'Forecast Version?'. Put the tick manually on the cross with Forecast version (I can suggest formula, but really you need to set this tick one time and that's it);

2) Now create one more line item in existing module (something like Final Value) and the formula would look like: if 'Versions' Module'.'Forcast Version?' and Value=0 then Value[select: versions.plan] else Value

 

Thank you

yoskaneko

Lukasz,

 

Wow.

I didn't know about NEXTVERSION function.

I tested and works well.

Thanks!!

 

Yoshi