on 2024 Jan 09 9:31 PM
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?
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.