Skip to Content

Creating Gross profit % when GP value is Zero

I need to create Gross profit %age separately for each invoice but once the GP is Zero it gives an error that "A zero value error is encountered". Invoice GP can be of any reason i.e Sample invoices or services etc. i need to know that how to place condition that also accumulates data.?

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    Posted on Mar 06, 2017 at 10:25 PM

    Hi,

    Refer discussion https://archive.sap.com/discussions/thread/3618222

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 06, 2017 at 04:28 PM

    That's a SQL Div/0 error. Use NULLIF() syntax.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 07, 2017 at 04:14 PM

    Marco, i am very new to SAP and not a developer. i couldn't go through with your feedback. Can you please help me creating my report with attached query.


    capture.jpg (139.9 kB)
    Add comment
    10|10000 characters needed characters exceeded