Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
2 months ago

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

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

1 Reply

Sort By
  • TonyGonzalez's avatar
    TonyGonzalez
    Qrew Trainee
    2 months ago

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