Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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 ) )
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.
Added one column "=avg(aggr(sum(sales),prod))" (the one you started with) for clarity(?!?) 😉
Thanks
nice explanaion, very helpful to me