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).
 100 Points
 frustrated
Posted 9 months ago
Chris, Champion
 4,390 Points
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)
 100 Points
Thanks. After asking I realized that I had the field defined as a text field so I wasn't being shown the options.
 31,478 Points
Create a new field on the sync table. A 'formulanumeric' 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.
(Edited)
Related Categories

Ask about Quick Base functionality
 899 Conversations
 63 Followers