Set Expression

[upaliwije]

Hi Friends

sum (if(Len( Trim( NP_REFUND_DATE ) ) > 0 ,TOTAL))

my above set expression is working fine. But my following one is not working

sum (if(Len( Trim( NP_REFUND_DATE ) ) > 0  or if(Len( Trim( REFUND_DATE ) ) > 0,TOTAL)))

Pls help me to correct my above expression

[antoniotiman · Accepted solution]

Try :

sum (if(Len( Trim( NP_REFUND_DATE ) ) > 0  or Len( Trim( REFUND_DATE ) ) > 0,TOTAL))

[upaliwije]

Thanks a lot

[fkeuroglian]

Hi, try this

=if(len(trim(NP_REFUND_DATE))>0 or len(trim(REFUND_DATE))>0, sum(TOTAL))

Fernando