on 2022 Jul 22 9:15 AM
Hello,
is it possible, that I can take over values from another key figur but only from january until dezember this year and the values from next year from another key figure
Regards
Oliver
Request clarification before answering.
Hello,
sometimes IBP is so easy 🙂
I have a solution.
I use follow kf calculation
IF("PERIODID1"="$$PERIODID1CU$$","KF1@LEVEL","KF2@Level")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can use a period shift in the copy operator, if you need the values in your target key figure as stored values or cross-planning area.
When you want to just calculate, you have. Bunch of possibilities:
If you need to shift the periods and copy from Jan-dec last year into target for this year, you have simplified operator for period shift
If you want to have e.g. all in the past with zero, only current year from another key figure and then again zero, you can use if-clauses and check with period ID
When I want dto. identify a year but work in month bucket, I don’t have the first month available. For those topics you can attach an attribute to the time profile and compare that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Irmhild,
thanks for the repsonse.
I believe, I haven't catch it 😞
I have kf1 and kf2. Both kf's include values of the current year (Jan - Dec).
Now I have create a kf3. This kf3 should involve the values from the current year of the kf1. And kf3 should consider from January of the next year, take over the values of KF2
Thanks in advance
Oliver
User | Count |
---|---|
7 | |
4 | |
3 | |
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.