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

  • Get RSS Feed

3 Answers

  • Best Answer
    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

  • 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

  • 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.

    Add comment
    10|10000 characters needed characters exceeded