Discussions

Expand all | Collapse all

Simple formula to sum or average a column in a report

  • 1.  Simple formula to sum or average a column in a report

    Posted 03-23-2018 18:46
    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). 


  • 2.  RE: Simple formula to sum or average a column in a report

    Posted 03-23-2018 19:38

    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.



  • 3.  RE: Simple formula to sum or average a column in a report

    Posted 03-23-2018 19:54
    Thanks.  After asking I realized that I had the field defined as a text field so I wasn't being shown the options.  


  • 4.  RE: Simple formula to sum or average a column in a report

    Posted 03-26-2018 15:56
    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 Specialistmneil@mcftech.com Phone: 440-201-6050 ext. 476" width="300px">