count NULL in 'is like' formula

[DBAFrog]

I have {charge.Withdrawn} in [isNULL,1.00] and it hates me
so I tried in [Null, 1.00] and it is still wrong.

Can you pull a NULL field in a 'is like' formula? otherwise I have to build an OR stmt and I never get them right in CR.

thanks,

------------------
Curious by Nature,
Linux by Design

 

[MrBillSC]

The OR statement should be pretty simple:

If (IsNull({charge.Withdrawn}) or {charge.Withdrawn} = 1.00)

I find things work best if you check for IsNull before any other comparison.

 

[DBAFrog]

Sweet...
Worked like a charm. It also helped answer my long standing question of the OR syntax in a complex formula in CR.

Thanks again

------------------
Curious by Nature,
Linux by Design