Weighted average

[Anonymous]

Hi,

I have this challenge where I would like to calculate the average of product time across products (a, b, c).

The simple avg function gives me the average (10 + 100 + 300) / 3  =  137.

But i want the weighted average where sales quantity is taken into account: (10/90)*10 + (30/90)*100 + (50/90)*300 = 201.

How do i write an expression for this?`

/ Michael

year	month	product	sales quantity	product time
2016	august	a	10	10
2016	august	b	30	100
2016	august	c	50	300
			90

[sudhakar_budde]

Hi Marco,

I am facing the same challenge. But for the year 2016 I wanted to see the 201 as Michael asked on the totals!

Any ideas please?

Thanks

SB

[Rich5678]

Can someone please respond to MichaelWad's question..

How to get the Weighted Average in Total Row of Simple Table?