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?
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.
3 Likes