Hi, I am new to SQL and working on a Report, I have issue while generating Report that I can not Negate Values in Report, can any one help me out this issue?
I want if Transaction Type (TR_Typecode) is Return (Retn) it should reflect -values in Unit Price, else show Normal Values.
++++++++++++++++++++++++++++++++++++++++++
TR_Typecode Unit Cost Qty. Total
Issu 4.5 2 9
Retn -4.5 1 -4.5
===========================================