If currency(summary field) is blank formula help

Question

I have a currency summary field in my invoice table that shows "our cost" which is summarized from another table in out APP.

I would like to create a formula checkbox field that will be checked if the "our cost" field is blank in my INVOCIES table. Is this possible to do?

I have tried several formulas option in a checkbox formula field, the NZ function, as well as the Null function using another field I created and converted our cost to a text field.

I need to use this missing our cost field for several other things as well, but cannot get the formula right.....

Thanks

KellyLyons1 · Accepted Answer

That worked perfect!  Thank you as always!!

MarkShnierYou · Answer

Try setting the field properties for that summary field to not treat blank as zero. Then your IsNull will work.

Sign up

Login to the community