Pivot Totals

[NikosAnt]

Master Item New Amount :

If(INCMG_OUT_IND='I',Sum(ORDRD_AMT_BASE_CCY),Sum(ORDRD_AMT_BASE_CCY*-1),)

I would calculate the Net Amount in Pivot Table  :  ORDRD_AMT_BASE_CCY for INCMG_OUT_IND=Incoming and ORDRD_AMT_BASE_CCY for INCMG_OUT_IND=Outgoing but , the total is wrong

[NikosAnt]

[jyothish8807]

Hi Niko,

try like this:

If(INCMG_OUT_IND='I',Aggr(Sum(ORDRD_AMT_BASE_CCY),INCMG_OUT_IND,TXN.DT.autoCalander),

Aggr(Sum(ORDRD_AMT_BASE_CCY*-1),INCMG_OUT_IND,TXN.DT.autoCalander))

Br,

KC

[NikosAnt]

I try this

If(INCMG_OUT_IND='I',Aggr(Sum(ORDRD_AMT_BASE_CCY),INCMG_OUT_IND,[TXN_DT.autoCalendar.MonthRelNo]),

Aggr(Sum(ORDRD_AMT_BASE_CCY*-1),INCMG_OUT_IND,[TXN_DT.autoCalendar.MonthRelNo]))

and now the total is null -

[jyothish8807 · Accepted solution]

what about this:

sum(If(INCMG_OUT_IND='I',Aggr(Sum(ORDRD_AMT_BASE_CCY),INCMG_OUT_IND,[TXN_DT.autoCalendar.MonthRelNo]),

Aggr(Sum(ORDRD_AMT_BASE_CCY*-1),INCMG_OUT_IND,[TXN_DT.autoCalendar.MonthRelNo])))

[NikosAnt]

Perfect!!!