Null value check doesn't work

[harleen_singh]

Hello,

I am using following statement in backend to check and fill null values with 1 but it is not working

if(IsNull([Unit of Measure Code]),1,0) as ABC,

What may be the problem??

thanks
Lavi

[deepakk]

hi,

Try this code

if(IsNull([Unit of Measure Code])=-1 ,1,0) as ABC,

or

If(len(trim(([Unit of Measure Code])) =0,1,0) as ABC

Deepak

[harleen_singh]

@deepak,

          both statements not working

thanks

Lavi

[deepakk]

HI Lavi,

Can you attach any sample data. I can check at my end. Either of the above code should work or there might not be any null or blank data .

Deepak