Skip to Content

validate_expresion_error In Adding Calculation in Keyfigure in SAP IBP

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 02, 2017 at 04:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2016 at 08:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 03:56 PM

    Hi Lingaiah,

    Please see attached screenshot.

    consensusdemandqty.jpg

    Regards,

    Pravin Tikar

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2017 at 10:33 AM

    Thanks Lingaiah, now is working fine.

    Add comment
    10|10000 characters needed characters exceeded