Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Total Media Problem

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!

1 Solution

Accepted Solutions
pgalvezt
Specialist
Specialist
Author

Got it!!

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

Thanks!

View solution in original post

4 Replies
Chanty4u
MVP
MVP

what is the result for this?

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

pgalvezt
Specialist
Specialist
Author

Hi,


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

Chanty4u
MVP
MVP

could you share sample app?

pgalvezt
Specialist
Specialist
Author

Got it!!

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

Thanks!