cancel
Showing results for 
Search instead for 
Did you mean: 

IBP Values from a key until dezember

OliverA41
Active Participant
0 Kudos
224

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

Accepted Solutions (0)

Answers (2)

Answers (2)

OliverA41
Active Participant
0 Kudos

Hello,

sometimes IBP is so easy 🙂

I have a solution.

I use follow kf calculation

IF("PERIODID1"="$$PERIODID1CU$$","KF1@LEVEL","KF2@Level")

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

OliverA41
Active Participant
0 Kudos

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