DEMAND_CALC() function

[aparna_ranganathan]

hi Experts

I need some help with the DEMAND_CALC() function. Iam using custom key figures for sales orders and forecast . If i pass these two custom key figures as parameters to the function along with other parameters , the demand_calc function dosent seem to work. Any idea how to solve the issue ?

Thanks

Aparna

[Former Member]

Hi Aparna,

We are using similar function and its perfectly working.

Our set up we are directing output of this function to a standard key figure DMDCON (Demand Forecast/SalesOrder)

The Input to this function is ACT_PRODUCT;ACT_LOCATION;'000';BUCKET_EDATE(ACT_COLUMN);ROW:SALES ORDER;ROW:FORECAST)

Thanks

Amulya

[aparna_ranganathan]

Amulya

This is exactly what we are doing - directing the o/p to DMDCON key figure. But nothing seems to work.

Thanks

Aparna

[aparna_ranganathan]

Okay here is some thing interesting - the DEMAND_CALC () function does does not work for a specific scenario. If the forecast value is non zero and the sales order value in the corresponding bucket is zero then the result of DEMAND_CALC does not show up (that is it isblank) for that bucket. Please note that both the sales order and forecast key figures are custom key figures. Any pointers please ?

Thanks

Aparna