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

[Former Member]

Hello All,

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

[piyush_parekh · Accepted solution]

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

[Former Member · Accepted solution]

Hello Piyush,

Those indeed marked as stored, not sure why you said those are calculated?

Thanks,

R

[piyush_parekh · Accepted solution]

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.

[Former Member]

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.

[Former Member]

here is the calculation

[Irmi_Kuntze]

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.