# 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?

Tags:

## Help Article Resources

#### Categories

- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives

Want to practice working with formulas directly in Smartsheet?

Check out the

Check out the

**Formula Handbook template!**