Creating a formula with a blank field 1

[helphelen]

Hello - I would like to create an 'if' formula with a blank field. Meaning, if({employee})= "blank" then = "No" else...
How do I properly convey this idea.

Thanks!

 

[jmd0252]

if ?XXX? is null, now "null",, is a special term,, no spaces, no zeros,, ie "nothing"..

 

[fisheromacse]

as jmd said, null is a special term that doesnt mean blank, it means lacking data.
the below formula will check if the field is null or if the field is populated by just spaces, and treat them both the same.


//{@nullcheck}
IF (isnull({yourtable.yourfield}) or trim({yourtable.yourfield})="" then 0
else 1