Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 11:46 AM

    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
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.