Key figure formula facing in Excel front end

[former_member182607]

Hello,

I have a formula like this which looks OK with no error and correct calculation graph but Excel throws an error. Can somebody tell me why?

For me it looks a simple one but is not working.

Thanks,

Subash Nanjangud

S4PRODNRATE @PERPRODLOCRESSRC = IF ( ( "EPPULLRATE @PERPRODLOCRESSRC" = 0 OR ISNULL( "EPPULLRATE @PERPRODLOCRESSRC" ) OR "EPEFFIENCY @PERPRODLOCRESSRC" = 0 OR ISNULL( "EPEFFIENCY @PERPRODLOCRESSRC" ) ),NULL, "EPPULLRATE @PERPRODLOCRESSRC" * "EPEFFIENCY @PERPRODLOCRESSRC" * 24)

[former_member182607 · Accepted solution]

Thanks Nikhil,

I think after that we set right the parantheses again but still did not work. It is with SAP and what they have gotten back to us is that the Key Figure EPEFFICIENCY has a BLANK 9Of one length 1). So they are still trying to figure that out.

Subash

[former_member194529]

Hi Subash,

I am afraid this error message is too generic for further analysis. I would suggest you raise an incident for SAP Support to have the issue analyzed further by checking back-end logs.

Best regards,

Ivan

[Former Member]

Subash,

It might be case of missing parenthesis.

Try if this works

S4PRODNRATE @PERPRODLOCRESSRC = IF (( "EPPULLRATE @PERPRODLOCRESSRC" = 0) OR (ISNULL( "EPPULLRATE @PERPRODLOCRESSRC" )) OR ("EPEFFIENCY @PERPRODLOCRESSRC" = 0) OR (ISNULL( "EPEFFIENCY @PERPRODLOCRESSRC" ))),NULL,("EPPULLRATE @PERPRODLOCRESSRC" * "EPEFFIENCY @PERPRODLOCRESSRC" * 24)

Regards, Nikhil

[former_member182607]

Hello,

I have been told that my KF EPEFFIENCY has a blank space in disaggregation field. I created a new KF and apparently that also has the same issue. They are looking into the cause. I will update when the solution comes.

Thx,

Subash

[former_member182607]

Thanks Ivan... it is already with SAP Brazil. I also fail to understand why messages can't be a little more meaningful.

Subash

[former_member182607]

ibp-error.jpg

Here is the attachment, Nikhil.

Thanks,

[former_member182607]

Thanks Nikhil...I will do that tomorrow when I get to wrk.

Subash

[Former Member]

Hi Subash,

Can you share the error message and log.

Regards, Nikhil