Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a bit confused about the difference in results I get for total of ratios.
In the following table I have used
1.Sum of rows (yellow)
2.Average of Rows (green)
3. Average of a ratio calculated in the script for each product group (orange)
My question is why is there a difference between sum of rows and average of rows? Which is "preferable"?
Thanks!
Yes, the expression total is the weighted average.
Here is an example to help you decide:
If you only have 2 BUs and one of them has $5M/$10M of actual vs planned sales and the other has $20k/10k of actual vs planned sales, then if you want the total ratio to be of the company, you should use the expression total (yellow). (5.02M/10.01M=50.1%) If you want the average ratio of all the BUs, then you use the average (green). (average(50%,200%)=150%).
When the total company sales is almost 50% behind plan, do you want the column total to show you are 50% ahead of plan?
Hi Mike,
Thanks for your reply!
Not sure I understand ..
I used Expression Total (yellow) and Average (not Sum) of Rows (green) .
is the Expression Total considered a weighted average?
I was looking to find out what is the right way to present a total of a ratio..
Thanks!
Yes, the expression total is the weighted average.
Here is an example to help you decide:
If you only have 2 BUs and one of them has $5M/$10M of actual vs planned sales and the other has $20k/10k of actual vs planned sales, then if you want the total ratio to be of the company, you should use the expression total (yellow). (5.02M/10.01M=50.1%) If you want the average ratio of all the BUs, then you use the average (green). (average(50%,200%)=150%).
When the total company sales is almost 50% behind plan, do you want the column total to show you are 50% ahead of plan?
Got it!
Thanks!