Disaggregation Expression - ISNULL not working

[drbanning]

My original config, which works without issue, simply points to the ZSTATFCSTBF KF for proportionality.

I am trying to set a disaggregation expression in my SFBF override to check the SFBF first then default to the Proportional Factors, so that I have a backup if there is no stat existing for a combination. All KF's are stored and exist at the same base planning level.

Within my disaggregation expression my calculation is

IF ( ISNULL ( "ZSTATFCSTBF" , "ZPROPFACTORS" , "ZSTATFCSTBF" )

but when I attempt to save the config - the error message states

There is an error in the disaggregation expression.

ZFCSTDMDOVERRIDE: Please check the validity of the disaggregation expression.

What am I missing in my syntax? I followed the configuration example in https://launchpad.support.sap.com/#/notes/2365315

Thanks,

dan

[Irmi_Kuntze · Accepted solution]

Try

IF ( ISNULL ("ZSTATFCSTBF") , "ZPROPFACTORS" , "ZSTATFCSTBF" )

The closure bracket after the "ZSTATFCSTBF" is missing

Yours, Irmi

[drbanning]

Thank you - I thought I had tried that variant, but obviously I missed something on it.

It accepted the change and is activating now.

[lokesh_reddy4]

Hi, syntax error is bracket not closed after condition in the equation.It should be IF ( ISNULL ( "ZSTATFCSTBF"),”ZPROPFACTORS" , "ZSTATFCSTBF" )

Thanks and Regard’s

Lokesh