Avg not as expected

[hopkinsc]

Hi All,

I have a table of stats  split by Region / Sub Region/ Sales Person. I am not trying to show the averages in another table by Region but the avg's are different to what i get if i export the first table into Excel . 

Can anyone see what i am doing wrong with the attached?

In excel i get 8.2

[sunny_talwar · Accepted solution]

Try this expression

=Avg(Aggr(
	Count(_%Visit)/Count({<[Image Level], [Group Outlet Type]>}DISTINCT [Worked Day])
, Territory, [Sales Rep], Region))

[hopkinsc]

Thanks Sunny, that works!

I have noticed that you have removed the = from the set analysis, was there a reason for that?

[sunny_talwar]

Sorry that is just out of habit. Having FieldName = is equivalent of FieldName. You can add that back.