SUM Function

[upaliwije]

Dear Friends

sum(if (TRAN_TYPE='NEW', 1,if(TRAN_TYPE='RENEWAL',1))AND if(IsNull(Sent_Date)=0)

I have done above expression but it is not working. My expected result is

If TRAN_TYPE='NEW',  or 'RENEWAL' one record should be summed provided Sent_Date  is not null

Pls help me.

[its_anandrjs]

Hi,

Write like

=sum(if(Match(TRAN_TYPE,'NEW','RENEWAL') AND IsNull(Sent_Date)=0,Value))

and i think your syntax in missing some identity please check that one, also if possible provide any sample data.

Hope this helps

Thanks & Regards

[MarcoWedel · Accepted solution]

sum(if ((TRAN_TYPE='NEW' OR TRAN_TYPE='RENEWAL') AND IsNull(Sent_Date)=0, 1))

regards

Marco

[its_anandrjs]

Hi,

Yes you may write some thing this also

=sum(if(Match(TRAN_TYPE,'NEW','RENEWAL') AND IsNull(Sent_Date)=0,1))

Hope this helps

Thanks & Regards

[upaliwije]

Thanks a lot

[MarcoWedel]

you're welcome