Treat blank as "0" is not the default when creating a new look-up field.

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

When I add a 2nd & 3rd & 4th relationship between the same 2 tables and add a numeric look-up field....

Treat blank values as "0" in calculations is not checked.  This is causing a enormous amount of extra steps so that my final calculations calculate.

Please note...the field IS checked in the initial table to table relationship.

Please advise

Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb
Any updates on this issue?  Thx
Hey Lynne,


If you are still having issues with this, I would recommend you open a support case with our Care team by logging into QuickBase, going to Help from any screen and selecting Manage Support Cases. From the support portal you can update the case.