Forum Discussion
arvindarvind24
Helper II
Helper IIAverage on selected Value
Hi, Need to calcuate Average on selected Value. Product Style No Sale Qty Avg Sales Qty Sales Qty/ Avg Sales Qty CD SET 1 30 6.26 4.79 CD SET 2 28 6.26 4.47 CD SET ...
arvindarvind24Helper II
Helper IIHi tamerj1 ,
Based on product i need the average.
| Product | Size | Style No | Colour | Sale Qty | Avg Sales Qty | Sales Qty/ Avg Sales Qty |
| Product01 | S | 1 | Red | 30 | 12.63 | 2.38 |
| Product01 | M | 2 | Black | 28 | 12.63 | 2.22 |
| Product01 | XL | 3 | Green | 14 | 12.63 | 1.11 |
| Product01 | XXL | 4 | Red | 13 | 12.63 | 1.03 |
| Product01 | S | 5 | Black | 11 | 12.63 | 0.87 |
| Product01 | M | 6 | Green | 9 | 12.63 | 0.71 |
| Product01 | XL | 7 | Red | 8 | 12.63 | 0.63 |
| Product01 | XXL | 8 | Black | 7 | 12.63 | 0.55 |
| Product01 | S | 9 | Green | 7 | 12.63 | 0.55 |
| Product01 | M | 10 | Red | 6 | 12.63 | 0.48 |
| Product01 | XL | 11 | Black | 6 | 12.63 | 0.48 |
| Product02 | S | 12 | Green | 5 | 3.83 | 1.31 |
| Product02 | M | 13 | Red | 5 | 3.83 | 1.31 |
| Product02 | XL | 14 | Black | 4 | 3.83 | 1.04 |
| Product02 | XXL | 15 | Green | 4 | 3.83 | 1.04 |
| Product02 | S | 16 | Red | 4 | 3.83 | 1.04 |
| Product02 | M | 17 | Black | 4 | 3.83 | 1.04 |
| Product02 | XL | 18 | Green | 4 | 3.83 | 1.04 |
| Product02 | XXL | 19 | Red | 4 | 3.83 | 1.04 |
| Product02 | S | 20 | Black | 3 | 3.83 | 0.78 |
| Product02 | M | 21 | Green | 3 | 3.83 | 0.78 |
| Product02 | XL | 22 | Red | 3 | 3.83 | 0.78 |
| Product02 | S | 23 | Black | 3 | 3.83 | 0.78 |
| Product03 | XL | 24 | Green | 3 | 2.54 | 1.18 |
| Product03 | XXL | 25 | Red | 3 | 2.54 | 1.18 |
| Product03 | S | 26 | Black | 3 | 2.54 | 1.18 |
| Product03 | M | 27 | Green | 3 | 2.54 | 1.18 |
| Product03 | XL | 28 | Red | 3 | 2.54 | 1.18 |
| Product03 | XXL | 29 | Black | 3 | 2.54 | 1.18 |
| Product03 | S | 30 | Green | 2 | 2.54 | 0.79 |
| Product03 | M | 31 | Red | 2 | 2.54 | 0.79 |
| Product03 | XL | 32 | Black | 2 | 2.54 | 0.79 |
| Product03 | M | 33 | Green | 2 | 2.54 | 0.79 |
| Product03 | M | 34 | Red | 2 | 2.54 | 0.79 |
| Product | Sales Qty | Avg Value |
| Product01 | 139 | 12.63 |
| Product02 | 46 | 3.83 |
| Product03 | 28 | 2.54 |