Help for DEMAND_CALC() Function usage

[sumaghosh]

Hello All,

I need help with usage of function mentioned in the Discussion Query above.

I get error given below( snap) while I am trying to use this function : Demand_Calc() .

The purpose of using this function is to Capture SKUs with no demand, so...I am trying to find out total demand, then will design the macro further, but I am stuck in the below step.

Urgent help would be much appreciated!!

Thanks.

Note : I am using empty Key Figure Number of orders just like that since it is unused KF.

[Abhishek_Kunchala · Accepted solution]

Suma,

What is CON_BUCKET_EDATE function that you are using? Use BUCKET_EDATE instead, Moreover, your "Total Demand" and "Total Forecast" need to be declared via rows not just as text.

Please look at the attached example.

Regards

AK

[sumaghosh · Accepted solution]

Thanks Abhishek for your valuable inputs and help.

After using BUCKET_EDATE() function system gives error this function is not available , use CON_BUCKET_EDATE() instead. Hence, I had used it.

After replacing the texts with rows it works fine!!

[kenneth_snyder · Accepted solution]

There is no macro function CON_BUCKET_EDATE.