Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
8 months ago

Make totals on a table into averages

I have table that I columnar averages, not totals.  I can't find that setting.  Screenshot attached.



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
  • np :)

    It's a field setting. 

    The reasoning for that is that inherently some fields makes sense to have totals and some fields don't. Some fields makes sense to have averages and some fields don't.

    For example [unit price] makes no sense to have a total unit price but if you had a field called [extended price] then for sure that would be worthy of totals.   So you just set it once at the field level and you don't have to set that for every report you build.  

    Mark



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------