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...
Forum Discussion
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
------------------------------
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
------------------------------
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
------------------------------
------------------------------
Matt Hartman
------------------------------
- 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
------------------------------
