Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum
(if(trim(IS_MIN=1 and IS_MIN<>11 and IS_MIN <>0), (if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)), null())))
Hi,
sum(if(trim(IS_MIN=1) and trim(IS_MIN<>11) and trim(IS_MIN <>0),
((if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)))))
try this.
i hope it help's
Regards,
chandra
Hi,
sum(if(trim(IS_MIN=1) and trim(IS_MIN<>11) and trim(IS_MIN <>0),
((if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)))))
try this.
i hope it help's
Regards,
chandra
It is giving o result, it is not working.
Thankyou for quick response
Regards
Akmal Imtiaz
Hi Akmal,
Can you explain in words what you want (your logic) ? and one more thing, if you verify a post, it means it is working for, you.
Regards, tresesco
CM and OTHER_CM may have null values ,du to this reason this statament is not giving result.
Regards
Akmal Imtiaz
Both of these statement are not working.
Statement no. 1
=
sum(
if
(trim(IS_MIN=1 and IS_MIN<>11 and IS_MIN <>0), (if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)), null()))
Statement no. 2
=
sum(if(trim(IS_MIN=1) and trim(IS_MIN<>11) and trim(IS_MIN <>0), ((if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)))))
Hi,
please find attachment. i tried with one example, still u r not get solution post app with sample data.
Thanks,
Chandra
It is not working.
Thank you very much, it is working.