Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
i need to get the average price per products from sales. The problem is that the average is taking the number of "repeats" of the price into account. While i want to to know the average price per product.
So if this is the price per product:
In the sales table the price is shown per order like:
How can i get the right average price? I'm a bit stuck
Solved! Go to Solution.
Works like a charm! Thanks Ahmed for the quick help!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |