IBP KF Calculation - If

[OliverA41]

Hello,

I find this description how I can display the fcst error Mape in excel

https://blogs.sap.com/2016/05/18/how-to-display-the-error-measure-eg-mape-from-statistical-forecasti...

But If I want create the kf WKFCSTMAPEC@WKPRODLOCCUST I get the error message, that the follow calculation is not correct

IF( “PERIODID4” = “$$PERIODID4CU$$” , “WKFCSTMAPEC1@WKPRODLOCCUST” , “WKFCSTMAPE@WKPRODLOCCUST” )

"The calculation definition WKFCSTMAPEC@WKPRODLOCCUST contains an error. Syntax error in the calculation expression"

I don't find the mistake

Regards

Oliver

[Irmi_Kuntze · Accepted solution]

Hi Oliver

that blog is super old and was created before all the extra syntax checks have been introduced the last 2 years, so yes it might not work any more exactly the same way 🙂

And it was created before there was the FC error calculation app. Since that new app exists, I have not build this workaround any more

However, if I had to, I would make it more simple:

WKFCSTMAPEC@WKPRODLOCCUST = FORECASTMAPE@WKPRODLOCCUST”

And

FORECASTMAPE@WKPRODLOCCUST = “FORECASTMAPE@PRODCUSTLOC” with an additional KF as input KF that you have on the same level WKPRODLOCCUST, or any KF that is on e.g. WKPRODLOC should do as well

And in the (advanced meanwhile) copy operator I make sure that I only copy the one value for the week, instead of having the calculation with PERIODID - where I think the error is coming from

Yours

Irmi