Correct Percent calculations on MR Report Totals
When calculating a percentage from MR report data points, the period percentages calculate correctly, but the column with totals will not calculate the correct percentage. It will total all of the period percentages. In this example, the Contribution Margin is calculated, and, for each month, the calculations are correct. However, the YTD contribution Margin is a total of the three months. 58.1% + 58.1% + 56.0% = 172.2%. This can be frustrating to deal with.
To resolve this issue, change the Calculation Priority on the Settings tab of the report. Normally change the priority from Row first to Column first.
Now, the contribution margin percentage is calculated based on the total Contribution Margin/Total Revenue instead of a total of all the contribution margin percentage.
Views:
Keywords: Management Reporter percent calculations