Adding IsNull to If Statement to Expression

[#1]

Hi,

I'm struggling to find the right syntax in adding a if(IsNull to an existing expression:  Here is the existing expression:

if([Salespercent]<.90, 0,

if([Salespercent]>=.90 and [Salespercent] <=.957, 2,

if([Salespercent]>=.958, 3

)))

I need to add an IsNull to the expression so if the [SalesPercentField] is Null it returns 0

Can someone please help?  Thank you.

Brian

[#2]

Hi Brian,

you can just put the 0 into you final else condition, which will catch any null as they will fall out of all of your prior true statements.

if([Salespercent]<.90, 0,

if([Salespercent]>=.90 and [Salespercent] <=.957, 2,

if([Salespercent]>=.958, 3,0

)))

hope that helps

Joe

[#3]

Thanks!

[Colin-Albert]

You can test if the field length is zero

If( len( [SalesPercentField] ) > 0, 'Field is not null', 'Field is null')