Dear community,
I want to create the followinng KF :
I know that the current period is defined as "$$PERIODID0CU$$"
But what about the "Period -12 months"?
Thank you for your support
Kind regards
Vasilis
Hello Vasilis,
First, using attribute transformation for PERIODID (PERIODID+12), get a value of "Actual of period -12 months". You can get the calculation details of this in the configuration guide, under the chapter, "Example: Attribute Transformation". Specific example is 'Period Offset".
Then further enhance it based on your requirement. Do you want to subtract it from current period always or it is subtracted from the corresponding period (ie JUN-2016 value will be subtracted from JUN-2015)?
If you want it to be subtracted from the current value always, then you can get the value of current Actual in a Helper KF and use it in your calculation. If you subtract from the PERIODID, then you just need to subtract Actual KF from the "Period Offset" KF.
Best regards
Rinju
Add a comment