cancel
Showing results for 
Search instead for 
Did you mean: 

How to declare the "period-12 months" in the calculation definition

Former Member
0 Kudos

Dear community,

I want to create the followinng KF :

  • "Actuals of current period"- "Actuals of period -12 months"

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank you Rinju for your support,

If I don't push you too much, would you please give me an example?



I want to subtract JUN-2015 value from JUN-2016 value.



Thank you very much for your help


Best regards


Vasilis

Former Member
0 Kudos

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

Answers (0)