validate_expresion_error In Adding Calculation in Keyfigure in SAP IBP

[pravin_tikar1]

Hello All,

I have created keyfigures and adding calculation to Consensusdemandqty as below

CONSENSUSDEMANDQTY@PERPRODUST

IF(ISNULL(“CONSENSUSDEMANDQTY@PERPRODCUST”), “SALESFORECASTQTY@PERPRODCUST”, “CONSENSUSDEMANDQTY@PERPRODCUST”)

But getting error as "validate_expresion_error".

Is anything I missed?

Regards,

Pravin Tikar

[lingaiahvanam · Accepted solution]

Hi Pravin,

It seems no issue with the logic, can you delete this key figure and create new one with different namining conversion like (CONSENSUSDEMANDQTY1).

Best Regards,

Lingaiah

[pravin_tikar1]

Thanks Lingaiah, now is working fine.

[pravin_tikar1]

Hi Lingaiah,

Please see attached screenshot.

consensusdemandqty.jpg

Regards,

Pravin Tikar

[lingaiahvanam]

Hi Pravin,

Can you share the screen shot of key figure caluclation.

Example below:

Check the input key figure - Request level do not select the Stored.

Other key figures it dependent on calculations from privous key figure either stored or calculated.

Best Regards,

Lingaiah