topic Re: Total Media Problem in QlikView

Total Media Problem

pgalvezt — Mon, 18 Jun 2018 17:12:01 GMT

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 — Mon, 18 Jun 2018 17:19:07 GMT

what is the result for this?

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

pgalvezt — Mon, 18 Jun 2018 17:27:20 GMT

Hi,

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

Chanty4u — Mon, 18 Jun 2018 17:28:17 GMT

could you share sample app?

pgalvezt — Mon, 18 Jun 2018 20:24:33 GMT

Got it!!

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

Thanks!