Forum Discussion

MattHartman's avatar
MattHartman
Qrew Trainee
5 years ago

Formula field not populating for some records

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 sev...
Formulas and functions
Tables and fields
MattHartman's avatar
MattHartman
Qrew Trainee
5 years ago
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------