Skip to main content
Question

Need an Average, but it's counting NULLS as a zero

  • March 7, 2024
  • 0 replies
  • 71 views
Forum|alt.badge.img+4

I need an average of the # of FT column.  Because of the schema, it's counting nulls, thus essentially cutting the average in "half".  I KNOW this can be fixed, I am just struggling.  Might be because I am too many beers in, but I really want to conquer this tonight.  :) 



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+4
    • TonyGonzalez
    • Author
    • Registered
    • March 7, 2024

    I swear, there is something very eye-opening about posting in this forum.  I posted it and the lightbulb went off.  The field setting to count blanks as "0" was checked.  Why, I have no idea.  Maybe that's the default.  But, unchecking it solved the problem.  Sorry for clogging up the forum.  I will try and be better.



    ------------------------------
    Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
    IT Director City of New Braunfels
    ------------------------------
    Terms & ConditionsAccessibility statement