check this statement it is not working (Aoiding null values)

[#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())))

[#2 · Accepted solution]

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

[#3]

It is giving o result, it is not working.

Thankyou for quick response

Regards

Akmal Imtiaz

[tresesco]

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

[#5]

CM and OTHER_CM may have null values ,du to this reason this statament is not giving result.

Regards

Akmal Imtiaz

[#6]

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)))))

[#7]

Hi,

please find attachment. i tried with one example, still u r not get solution post app with sample data.

Thanks,

Chandra

[#8]

It is not working.

[#9]

Thank you very much, it is working.