on 07-22-2016 12:06 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vasilis,
I am not sure what extra information I can provide than what is already available in the configuration guide. As you would have already seen in the configuration guide, using configuration of KF ACTUALSQTY1YROFFSET@MTHQTRYEARPRODCUST, you will get 'Actuals of period -12 months". Then you can add one more KF (calculated KF) like:
ACTUALSQTDIFFFRM1YROFFSET@MTHQTRYEARPRODCUST=ACTUALSQTY@MTHQTRYEARPRODCUST - ACTUALSQTY1YROFFSET@MTHQTRYEARPRODCUST
and then this should give you the desired result.
In case you do not want to see ACTUALSQTY1YROFFSET@MTHQTRYEARPRODCUST in the excel, then you can configure it as Helper KF as well and use it in the above calculation.
Hope this helps.
Best regards
Rinju
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
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.