SAP IBP Copy key figures value to another key figure based on IF condition

[nitin_gupta21]

I have a simple scenario where I need to copy stat forecast key figure to final forecast key figure if the forecast override key figure is having no value or else copy forecast override key figure to final forecast key figure. Is this possible to achieve this by COPY planning operator. Or calculated key figure is a required. In SAP APO it is a simple macro but not sure how to get this done in IBP.

[lingaiahvanam · Accepted solution]

Hi Nitin,

You can try below case 1

You can write the logic like

IF Copy Statistical Forecast key figure is Null or 0, Copy Statistical Forecast values into Copy Statistical Forecast Key figure.

Create the copy operator to copy statistical forecast to Final Forecast key figure.

Please let me know if this scenario works for your requirement. If not explain with example.

Best Regards,

Lingaiah

[nitin_gupta21 · Accepted solution]

Hi Lingaiah,

Thanks for the reply.Below is my scenario. For Wk1 since there is no override final forecast is same as stat forecast. For wk 2 since user has put in override forecast, my final forecast is equal to forecast override. My question in IBP demand how can I achieve this logic. Do I need to use calculated key figure or helper key key figure or a mix of both.

[lingaiahvanam]

Hi Nittin,

You can write the logic as below,

STATISTICAL FORECAST = Value from statistical forecast algorithm

FORECAST OVERRIDE = Calculated key figure value from STATISTICAL FORECAST (Copy IF ISNULL)

FINAL FORECAST = IF ISNULL FORECAST OVERRIDE key figure copy value from STATISTICAL FORECAST and IF=0 or other override value copy FORECAST OVERRIDE value to FINAL FORECAST.

Let me know if this logic is workign or not.

Best Regards,

Lingaiah

[nitin_gupta21]

Hi Lingaiah,

I wrote below calculation for the key figure. I did not get any error and also I was able to activate the planning area. But when I am loading the data in excel the key figure "NXGTOTFCAT" is coming as blank although there are values in either "NXGSTATFCST" or "NXGCORFCST"