3 Replies Latest reply: Jan 11, 2017 5:13 AM by Mindaugas Bacius RSS

    A total with NUM, not affected by filters

    Jon Spacht

      I am trying to display average length in a text box with =NUM (Avg(AMSLength),'#,##0') .

      When I apply a filter, the average length changes to the average for the selected values.

      How can I get an average length for all values in the database, not affected by filters?