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 ?
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)
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 ?