Average Calculation

[roee1983]

Hi All,

is  there any chance to calculate both  average and sum toghther in the same expression?

i need the average  for total accuracy by countries average (sum(accuracy))  .

thanks

Roee

[Gysbert_Wassenaar · Accepted solution]

If you want to nest aggregation functions, for example the average of sums, you need to use the aggr function.

Something like avg(aggr(sum(accuracy),country)) to get the average of the sums of accuracy per country.

[roee1983]

Thanks!!

i did it wrong

aggr(avg(...)

thank u very much!

Roee