Skip to Content
author's profile photo Rahul Kumar
0
Rahul Kumar

Forecast Accuracy Not visible on Excel planning view even calculation is correct?

Posted on Oct 23, 2019 at 03:05 PM 85 Views

Hello All,

I am unable to see the Forecast accuracy for the "CED Baseline Stat Fcst FA" KF?

baseline-stat-fa.png (12.3 kB)
kf-calculation.jpg (62.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Piyush Parekh
    Piyush Parekh
    Posted on Oct 24, 2019 at 12:25 AM
    0

    Hi,

    It looks like input key figures for CEDFINALSTATFCSTFA i.e. CEDFINALSTATFCST and CEDACTUALSFINALQTY are stored key figures but marked as calculated in the calculation definition of CEDFINALSTATFCSTFA. Please mark them as stored and let us know if it works.

    Regards,

    Piyush

    Add a comment
    10|10000 characters needed characters exceeded

    • Piyush Parekh
      Oct 24, 2019 at 02:44 PM

      I meant input key figures should be marked as stored in the target key figure calculation defined at MTHPRODLOCCUST level. I was referring to the screenshot shared by you in the earlier comment. So once you write a calculation, click on validate and select the key figure input as "Stored". This will put a cube in front of those input key figures - just like shown in the CEDFINALSTATFCST key figure. Notice how "UOMCONVERSIONFACTOR" is marked as "stored" input in the calculation definition of CEDFINALSTATFCST key figure. There is a small cube after UOMCONVERSIONFACTOR@PRODUOMTO.

      Similar to that, mark stored inputs in the CEDFINALSTATFCST and CEDACTUALSFINALQTY key figure for a calculation definition of CEDFINALSTATFCSTFA key figure at MTHPRODLOCCUST level. I am referring to below calculation.

      uhgf.png (74.0 kB)
    Comment on This Answer
  • author's profile photo Irmhild Kuntze
    Irmhild Kuntze
    Posted on Oct 23, 2019 at 03:17 PM
    0

    According to your screenshot, "CED Baseline Stat Fcst FA" is system editable. Can you share HOW you let the system calculate it? Share screenshot of configuration plus the business log.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Rahul Kumar
    Rahul Kumar
    Posted on Oct 23, 2019 at 03:31 PM
    0

    So if you see above KF calculation screenshot, its calculating Accuracy based on the Actuals which we have in the system. I am not sure which business log you are asking?

    we assume its a simple calculation per actuals and Baseline fcst data.

    Add a comment
    10|10000 characters needed characters exceeded

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.