Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try it with: =NUM (Avg({1} AMSLength),'#,##0')
- Marcus
You can use the Set expression to avoid the Filter selections
=NUM (Avg({1}AMSLength),'#,##0')
To understand what is suggested read more about Set Analysis.