Percentages not displaying correctly in Report Summary

Hi,

In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be common to the error (2104 - Norval in the instance below). I've checked the source sheets and can't see any obvious issues.

Any clues what it causing this?

Many thanks,

Richard



Tags:

Best Answer

Answers