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
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.
ToNumber([Text Field])
Then enable the properties for totals/averages as desired.