Total Media Problem

[pgalvezt]

Hello,

I need to obtain price average, my formula is:

=Num(Sum(Aggr(Sum(Sales)/Sum(Quantity), Product)),'#.##0')

Detail results are correct, but the total is not the right number.

I need to obtain 1.146 but i have obtained 29.786.

Thanks!

[Chanty4u]

what is the result for this?

Aggr(Sum(Sales)/Sum(Quantity), Product)

[pgalvezt]

Hi,

Aggr(Sum(Sales)/Sum(Quantity), Product -->Gives Null

[Chanty4u]

could you share sample app?

[pgalvezt · Accepted solution]

Got it!!

Num(Avg(Aggr(Sum(VentaNeta)/Sum(Cantidad), AgrupacionProducto)),'#.##0')

Thanks!