Forum Discussion

MattHartman's avatar
MattHartman
Qrew Trainee
4 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 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
------------------------------
Formulas and functions
Tables and fields

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    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's avatar
      MattHartman
      Qrew Trainee
      4 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
        Qrew Champion
        4 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
        ------------------------------