Skip to main content
Question

Formula field not populating for some records

  • August 7, 2020
  • 0 replies
  • 33 views

I have a formula field that subtracts one other formula field:

"Company 1 Total Fees" - "Company 2 Total Fees" to get "Company 2 Savings"

Both "Total Fees" fields are formula fields and have several other fields calculated within the record. 

For some reason, only about 2% of the "Company 2 Savings" fields have values even though all "Total Fees" fields are populated.

Can't figure out why this is happening. Anyone have an idea?

Thank you!

------------------------------
Matt Hartman
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
It probably has to do with how you are treating nulls.

Can you post the formulas for the first two fields?

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