As you can see, the Target% summary is incorrectly calculated as the sum of 112.1 + 262.3. The correct value is 192.3 (4323/2248).
This is caused when the summary was made before adding percentage calculation. The more complicated fix is to delete the summary, add the percentage calculation, then summarize the data.
A simple fix can be done however, by setting the Solve Order of the percentage data item to a higher value. This will result to calculating that data item last. In this case, the Solve Order property is set to 2.
After running the report, the correct value is obtained.
No comments:
Post a Comment