AGGR()

[Anonymous]

hello everyone,

i have below table, i want to used AGGR function to calculate average.

i am not getting why both o/p shows differ value if they calculate average.

it become difficult for me to find a difference between them.

=avg(aggr(sum(sales),prod))                          =avg(sales)

                     

why it shows different o/p if they calculate average ?

please let me know

thank you..

[Lucke_Hallbergson]

You have 12 sales and 3650 in total sales = 304,16667 in average sales per deal.

You have 10 unique products sold and 3650 in total sales, average sale per unique product = 365

[Anonymous]

ok but tell me one thing in below expression why its not taking unique records

,it shows 304.16 o/p

= Avg( Aggr( Sum(sales), prod,code ) )

[Lucke_Hallbergson · Accepted solution]

If You want the average per sale when using aggr  =avg(aggr(avg(sales),prod, code)) will get the average sale per sale (not just product) eg 304,16667 if that is what You want.

[Lucke_Hallbergson]

[Lucke_Hallbergson]

Added one column "=avg(aggr(sum(sales),prod))" (the one you started with) for clarity(?!?) 😉

[Anonymous]

Thanks

nice explanaion, very helpful to me