Skip to Content

Key figure formula facing in Excel front end

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Feb 27, 2017 at 09:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12, 2017 at 04:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2017 at 12:14 AM

    Hi Subash,

    Can you share the error message and log.

    Regards, Nikhil

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2017 at 02:40 AM

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

    Subash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2017 at 07:28 PM

    ibp-error.jpg

    Here is the attachment, Nikhil.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12, 2017 at 09:07 PM

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

    Subash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 04:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2017 at 03:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded