Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])))
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
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 -
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])))
Perfect!!!