Query Debit and Credit into single line

[former_member820000]

Hi all

i want to ADD Debit and Credit into sing Colum

maybe there is way to make custom Column

do you guys know how to do it?

[venkateswaran_k]

If I understand your question correctly, you want to display only one Amount Column?

[former_member820000]

YES "Debit" "Credit" and "Dr/CR" Like this

[former_member820000]

YES "Debit" "Credit" and "Dr/CR" Like this total 3 Column

[venkateswaran_k]

Hi hswy11

SELECT T1.Refdate, T1.account, 
       T1.Ocrcode3,
       (T1.debit + T1.credit) as "Amount"
CASE WHEN T1.DEBIT > 0 THEN "DR" ELSE "CR" END AS "DRCR"
FROM OJDT T0 INNER JOIN JDT1 T1
ON T0.TRANSID = T1.TRANSID

[former_member820000]

My code looks not working

do you why?

[former_member820000]

If Credit Amount into single line Mark should be Reverse

do you know how to reverse Mark?

[venkateswaran_k]

What is the error ?

After the word "Amount", Put Comma

[venkateswaran_k]

CASE WHEN T1."Debit" > 0 THEN T1."DEBIT"  ELSE (-1*T1."CREDIT") END AS "DRCR"

Amount > 0 "==== is the correction