Simple formula to sum or average a column in a report
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).
Forum Discussion
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.