Formula on related numeric field?

Question

I'm trying to do a simple check to see if a related (numeric) field is null. How come this doesn't work?

If(isnull([Related Field], true,false)

I don't get any errors in the code, it just simply doesn't work. Is that not the correct way to check if a related field is null?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

All numeric data entry fields have a checkbox to ask whether a blank should be treated as zero. Typically they default to treat a blank as zero.

So you can either disable the checkbox or test if it is equal to zero.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community