# Maximum percentage value shows as decimal when using rollup function

**URL:** <https://community.glideapps.com/t/maximum-percentage-value-shows-as-decimal-when-using-rollup-function/77941>\
**Category:** Ask for Help\
**Created:** [November 15, 2024, 5:42pm UTC](https://community.glideapps.com/t/maximum-percentage-value-shows-as-decimal-when-using-rollup-function/77941 "2024-11-15T17:42:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicolas\_Maldonado](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_maldonado/32/36477_2.png) [@Nicolas\_Maldonado](https://community.glideapps.com/u/Nicolas_Maldonado)\
**Post date:** [November 15, 2024, 5:42pm UTC](https://community.glideapps.com/t/maximum-percentage-value-shows-as-decimal-when-using-rollup-function/77941/1 "2024-11-15T17:42:50Z")

</div>

I’m trying to find the maximum value of a percentage column using rollup (data comes from a google sheet). When I apply the rollup function with “Maximum” selected, instead of getting the highest percentage (12.34%), I’m getting all values converted to decimals (0.13). How can I maintain the percentage format while using rollup to find the maximum value?

 ![Screenshot 2024-11-15 at 12.41.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/350d0c7f246a58524fda86b2802a40bde1d23af1.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 15, 2024, 6:17pm UTC](https://community.glideapps.com/t/maximum-percentage-value-shows-as-decimal-when-using-rollup-function/77941/2 "2024-11-15T18:17:24Z")

</div>

Mathematically, percent is always a decimal of 100% (or 1.0). Using the percent symbol is just a representation of that decimal value multiplied by 100.

If you click on a cell to edit it, does it show the underlying decimal value? How were those percentages populated in the first place?

If you want your Rollup to show differently, add a math column that multiplies the result by 100 and add the percent symbol as a unit. You may want to also increase the precision in your Rollup column to 4 decimals.