How can I get the Summarize function in report to use a standard unit?

Trisha Martinez

I am writing a report, and the base data gives % of a person's effort. For some reason, when I sum the totals for a category, some of the groups give a whole number, and others give a % value.

In fact, it would be great to sum to a whole number, like the row for Total and the row for Sponsored, since 100% indeed equals 1.0 person. But even if it insisted on staying in % value, like those circled in red below, I'd be okay if it was consistent. Mixing types of units the report shows will absolutely confuse everyone.

Does anyone know how to make these formats consistent across all the summaries in a given column?