10 Replies Latest reply on Aug 13, 2018 2:08 PM by Julie Nguyen

    How to get average number for whole table data

    Julie Nguyen

      Hi,

       

      I want to create a calculated field name "AverageFloatingTime" in the "Data Source" tab to get the average #.  For example, my data source is below.  I want the AverageFloatingTime column to display 2.49 for all records.  Is that even possible?  2.49 is the average when adding all FloatingTime/5 records.  Please help.

       

      Date          FloatingTime  AverageFloatingTime

      5/1/2018     2.60

      6/1/2018     2.43

      7/1/2018     2.47

      8/1/2018     2.46

      9/1/2018     2.50

       

      Thank you.