How can i do weighted average function so that I got over two columns
Assuming you have two columns named value
and weight
, then you could calculate the weighted average as follows:
sum( value * weight)
/
sum(weight)
How can i do weighted average function so that I got over two columns
Assuming you have two columns named value
and weight
, then you could calculate the weighted average as follows:
sum( value * weight)
/
sum(weight)