cancel
Showing results for 
Search instead for 
Did you mean: 

Can I in IBP reference a Fixed period in Keyfigure calculations?

abarofsoap
Explorer
0 Kudos
386

I'd like to, from a fixed date or periodid, have a way to control from what period various calculated keyfigures on several planning levels should get it's value from.

For example; Actuals before fixed date 2024-01-01 and Forecasts from there and on.

The date should be set once and then never change. I would like it to be able to affect all keyfigures within a version.
The versions do share masterdata, so i guess using masterdata is out of the question...?

Can time independent keyfigures be used to store a periodid and reference in keyfigure calculations perhaps?
Any other suggestions on any good techniques I could try out?

View Entire Topic
abarofsoap
Explorer
0 Kudos

Formulas I can figure out, but my issue is that I don’t know where to store the periodid "27124". KF1@LP= IF("PERIODID5" >= "27124", ...)

To hardcode it into the formula is not an option as i want it to be a different value in each version.
I also need it to be easy to maintain, so i want to avoid storing it in a lot of time series based keyfigures on multiple planning levels etc.