The row format has 4 columns: This year, Prior Year, Inc/Dec, %Inc/Dec
Content of Database are for Expense items 1 to 10
Totals include all line items 1 to 10.
%Inc/Dec divides Inc/Dec over Prior Year.... Line item % is OK, but the total % is not. Total adds all the Line Item % instead of dividing total Inc/Dec over total Prior Year.
What should I do?
Wow, that's a bit of a confusing post. Here is what I think you mean.
You have a column Layout with the columns listed above (TY, PY, Variance, Variance%).
You also have 10 rows in the Row Format with a Total row below them.
In the Total Row and the Variance% column you are seeing the addition of the % values from the rows above (meaning the row formula is working) instead of the total Variance amount divided by the PY amount. There is a setting in the Report Definition that will affect this. By default it should be set so your results come out correctly but it may have been changed in testing.
Go into the Report in question, click the Settings Tab. On the left you will see a section called Calculation Priority. You want the option that says Perform Row Calculations then Column. Save then run the report again.
If this does not fix your issue or I have misinterpreted your situation please feel free to contact me directly at Rob.Iversen@MSXGroup.com. You can also visit our website http://MSXGroup.com for information about our services, support options, training classes and FREE webinars on FRx, Forecaster and Management Reporter.
Rob Iversen MSX Group http://MSXGroup.com Rob.Iversen@MSXGroup.com