KF calculation only for values where time period (year) < current year

[peter_casper]

Hi all,

I set up a stored/calculated key figure which values are a combination of its own values and values of another key figure. I applied the following logic which works perfectly fine:

KF1@LOCPRODCUSTWEEKLY = IF(ISNULL("KF1@LOCPRODCUSTWEEKLY"), "KF2@LOCPRODCUSTWEEKLY", "KF1@LOCPRODCUSTWEEKLY")

So in case the value of KF1 is NULL, the calculation logic takes the values of KF2. Pretty straight forward.

However I want to apply the above logic only for periods which year is less than the current year, i.e. only for periods of 2019, 2018 and so on. I already tried to incorporate the statement ""PERIODID6" < "$$PERIODID6CU$$"" but the system complains during activation that PERIODID6 isn't part of the input.

Did anyone apply a calendar year check so that a particalur routine only kicks in if the year of the period at any level below falls under this criteria?

Cheers, Peter

[lokesh_reddy4 · Accepted solution]

Hi Peter,

Please check your time profile if periodID6 is part of it.

And for 'Year' we use periodID1...

Thanks and Regards,

Lokesh

[peter_casper · Accepted solution]

Hi Lokesh,

that was the necessary hint to check the correct period ID. I used PERIODID6 which actually does not even exist. For whatever reason I linked that ID with the yearly level. After a recheck and changed the logic to PERIODID1 and it works now.

Thanks for pointing out the obvious.

Cheers, Peter