key figure calculation past-current-future logic and from-to period logic

[Daniele_Cuozzo]

we need to create a calculated key figure (KF) that incorporates the following elements:

1. Past values of one key figure (KF1).
2. Present and future values of another key figure (KF2).

This calculated key figure should take in account for these components in its calculation logic. For instance:

At time t, the value of the calculated KF may depend on:

	PAST	CURRENT	FUTURE
month	mar-24	apr-24	mag-24	giu-24	lug-24	ago-24	set-24	ott-24	nov-24	dic-24	gen-25	feb-25	mar-25	apr-25	mag-25	giu-25	lug-25
kf1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
kf2	10	10	10	10	10	10	10	10	20	20	20	20	20	20	20	20	20
k3	kf1	kf1	kf1	kf1	kf1	kf1	kf1	kf1	kf2	kf2	kf2	kf2	kf2	kf2	kf2	kf2	kf2

for example:

• KF1(t−1): Past value of KF1 (one period before).
• KF2(t): Present value of KF2.
• KF2(t+1): Future value of KF2 (one period ahead)
• kf3= IF(MONTH>= TODAY; KF2; KF1)

how is possible to use this logic in ibp calculation?

in addiction, is it possible to create ibp calculation with "FROM\TO PERIOD" logic?

	2023	2024
month	1	2	3	4	5	6	7	8	9	10	11	12	1	2	3	4	5	6	7	8	9	10	11	12
kf1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
kf2	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20	20
kf3	kf1	kf1	kf1	kf1	kf1	kf1	kf2	kf2	kf2	kf2	kf2	kf2	kf1	kf1	kf1	kf1	kf1	kf1	kf2	kf2	kf2	kf2	kf2	kf2

the kf3 logic is:

every years from month 1 to month 6 take in account kf1; from moth 7 to moth 12 take in account kf2

How can we create  an IBP calculation like the kf3, that take in account the value of KF1 from month 1 to  month 6 ;from moth 7 to moth 12 take in account kf2 , independent of the year?

thanks in advance

[peter_casper]

Hi @Daniele_Cuozzo,

this can be achieved by adding an IF statement to your calculated KF3 in the following way:

IF(("PERIODID3" => "$$PERIODID3CU$$"), "KF2", "KF1")

The number within the PERIODID represents the time level of your time profile. In this case 3 stands for months. However you need to reveal the correct number based on your indiviually used time profile.

Your other questions are related to the same logic and can be solved with small additions.

BR, Peter