Simple formula to sum or average a column in a report

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I have an imported/synced spreadsheet and I just want to sum and average the # of Assets column.  I can't figure out how to do this in the formulas.  In Excel it would be Sum(D2:Dn). 
Photo of Imani Brown

Imani Brown

  • 100 Points 100 badge 2x thumb
  • frustrated

Posted 9 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

The averaging or totaling of a column is in the properties for that field, "Allow Totals...", or "Allow Averages..." Again, go into the properties for the field, # of Assets, to indicate you want these on your report.

(Edited)
Photo of Imani Brown

Imani Brown

  • 100 Points 100 badge 2x thumb
Thanks.  After asking I realized that I had the field defined as a text field so I wasn't being shown the options.  
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Create a new field on the sync table.  A 'formula-numeric' field, and then convert the text value to a number.

ToNumber([Text Field])

Then enable the properties for totals/averages as desired.


Matthew Neil - Product Specialist
(Edited)