IBP Custom Keyfigure Calculation Issue

[itsdyanmite]

Hi there,

I am trying to create a calculation scheme for customized key figures. All are on the same planning level.

Below is the case:

(i) ZCONSENSUSDEMANDCORR (Disaggregation based on Statistical Forecast)

(ii) ZDPOVERWRITE (Disaggregation Based on Sales Manager Forecast Quantity)

Output Key Figure = CONSENSUSDEMANDQTY (This one flows to supply Planning)

The reason I am using two key figures is that two different planning teams responsible for different set of products have their own desired disaggregation scheme as mentioned above but the output key figure is one.

At once, only one of the input key figure will have data in it so I thought it is easy to take inputs. I've written a calculation definition without any validation issues but getting SQL errors on Planning Area activation and also it is not working as desired.

I've attached the screenshot to elaborate more what I am trying to achieve, any help will be appreciated.

[guglanigaurav1987]

HI Hammad,

Your Calculation doesn't make any logical sense. Try This

IF(ISNULL("ZCONSENSUSDEMANCORR@WKPRODLOCCUST) AND ISNULL("ZDPOVERWRITE@WKPRODLOCCUST), "ZTOTALSALESFORECAST@WKPRODLOCCUST", IF(ISNULL("ZCONSENSUSDEMANDCORR@WKPRODLOCCUST),"ZDPOVERWRITE@WKPRODLOCCUST","ZCONSENSUSDEMANDCORR@WKPRODLOCCUST))

Thanks
Gaurav