Formula field not populating for some records

Question

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
------------------------------

markshnier__you · Answer

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
------------------------------

matthartman · Answer

I think you're right. Thank you. I started fixing some of the nulls with IF statements in formula fields containing other fields with zeros that resulted in Null results, but there are zeros and resulting nulls in various fields so it's getting complicated! I think I will continue to troubleshoot that and come back on if it doesn't work out. Thanks again.

------------------------------
Matt Hartman
------------------------------

markshnier__you · Answer

You can also use the nz ( ) function to treat nulls as zero, but it's better not to have nulls when you really mean zero.

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

Forum Discussion

Formula field not populating for some records

Related Content

Auto populate prefilled records

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Delete Formula Button Error

Record Details