Forum Discussion
Weighted Average for Total Row
Hi guys, i have the following table that is not giving me the weighted average of margin as the total maring value: The Margin (marked in red) should be a weighted value of the ...
How is margin % calculated
It should be ideally
divide(sum(margin),sum(revenue))
It should be sumx(table,margin/revenue)
Can you please share the calculation.
Appreciate your Kudos.
How is margin % calculated
It should be ideally
divide(sum(margin),sum(revenue))
It should be sumx(table,margin/revenue)
Can you please share the calculation.
Appreciate your Kudos.
I used a wrong formular. Thanks that helped!