SQ01 - SHOW A POSITIVE AMOUNT

[Former Member]

Hi Experts,

I made a query with SQ01 and I need to show a negative amount as a positive amount. How can I do that?

Thanks in advance.

[Former Member · Accepted solution]

Hi Karina

               I had to display the net value of the canceled billing document as negative in the billing report. The cancelled billing document field gave it a short name CAN and created a local field with the logic CAN>0 N*-1. The images are attached here with.

Please go through the this content for adding local field

Thanks, hope it helps

[Former Member · Accepted solution]

Thank you so much for your attention!

[Former Member · Accepted solution]

Hi Karina,

                 you are very warmly welcome dear. Pass it on !.

[Former Member]

apart from what you've been suggested above, if you're bit fond of coding then go to SQ02 --> Extras --> create additional field and amend the sample code as per your requirement.

CLEAR ZXXX.

SELECT SINGLE KWERT INTO ZXXX FROM KONV

WHERE KNUMV EQ VBRK-KNUMV AND KPOSN EQ VBRP-POSNR

AND KSCHL EQ 'MWST'.

ZXXX = ZXXX* ( -1 ).

This shows that i picked the amount first in my local field named as ZXXX and put the logic to multiple it with -1. In case you need any further help on this, please feel free to ask. Thanks.

[Former Member]

Thanks Ineffable!

[Former Member]

Mention not at all Karina. Stay blessed and have a nice day ahead. Thanks