sum

[upaliwije]

I have a pivot table with following dimension and mesures

Dept                     Debit_Amount   Settled_Amount Cancelled_Amount     Balance

01341	621,620	166,645	0	0
02718	822,169	85,530	32,404	0
03588	536,376	5,550	0	0

I have written the following expression to obtain balance But It is not giving desired result. Instead show 0 values

SUM( Debit_Amount -Settled_Amount -Cancelled_Amount)

Pls help me to correct the expression

[its_anandrjs]

I believe you use the column names if so then remove the SUM from the expression.

(Debit_Amount -Settled_Amount -Cancelled_Amount)

[upaliwije]

Thanks

Still the Balance value is zero

[its_anandrjs]

Please elaborate more

what is mean for Debit_Amount,  Settled_Amount, Cancelled_Amount this are fields or column name in the chart.

[upaliwije]

load DEBIT_NOTE_NO,SETTLEMENT_DATE,SETTLED_AMOUNT AS SETTLED_AMOUNT;

sql

select Max(Ref_date)SETTLEMENT_DATE

,det_ref_C DEBIT_NOTE_NO ,

sum(NVL(det_hc_amt,0)) SETTLED_AMOUNT

from T_debtor

group by ref_C;

These are really fields as given above SETTLED_AMOUNT

[#6]

Try with before function, otherwise share your sample.QVW

Regards,

Chinni

[upaliwije]

It is not working

[upaliwije]

Hi

I got the correct answer. The Expression should be as follows

sum(DEBIT_AMOUNT)-sum(SETTLED_AMOUNT)-SUM(CANCELLED_AMOUNT)

Thanks all