cancel
Showing results for 
Search instead for 
Did you mean: 

Disaggregation Expression - ISNULL not working

drbanning
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Try

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

The closure bracket after the "ZSTATFCSTBF" is missing

Yours, Irmi

Answers (2)

Answers (2)

drbanning
Participant
0 Kudos

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
Active Participant
0 Kudos

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