Need to use formula field to flag blank numeric fields. Current strategies not working.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I'm using a formula field to identify if a record is missing data from certain numeric fields. I've tried both of the examples below and neither is working. What am I doing wrong?


If([Tune-up Type]="Post measurement" and IsNull([kWWinterSavings]), "Missing Savings"&"\n")

&

If([Tune-up Type]="Post measurement" and ToText([kWhCoolSavings])="", "Missing Savings"&"\n")

Photo of Taylor

Taylor

  • 52 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
I think the issue is that numeric fields default to treat blank as zero. Edit the field properties to uncheck that box and your first formula should work. Then a blank will be a null and only a zero will be a zero.
Photo of Taylor

Taylor

  • 52 Points
That worked! Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
Thx for letting me know!