cancel
Showing results for 
Search instead for 
Did you mean: 

IBP Custom Keyfigure Calculation Issue

itsdyanmite
Explorer
0 Kudos
248

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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