A total with NUM, not affected by filters

[#1]

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?

[marcus_sommer]

Try it with: =NUM (Avg({1} AMSLength),'#,##0')

- Marcus

[krishnacbe]

You can use the Set expression to avoid the Filter selections

=NUM (Avg({1}AMSLength),'#,##0')

[MindaugasBacius]

To understand what is suggested read more about Set Analysis.