Decimals in Column Totals

[DCH]

Alexander,

I am using the column totals function to average percent values. Is there a way to apply the Number format, Percentage and Progressbar settings to the total row? Right now my percent totals have many decimal places but the column values have none.

Thanks!

[Alexander Bautz]

Could you post a screenshot so I’m sure I understand how it looks in your setup?

Alexander

[DCH]

I couldn’t find one that had non-zero values right near the totals row. But the 0%s are formatted according with these Special Configurations, but the value in the total row shows 14.28571428571428

{"percentage":true,"suffix":"%","progressBar":true,"totalsType":"average"}

Attachments:

1. 

   vLookupColumnTotalPercents.png
   

[Alexander Bautz]

Hi,
You should be able to use the “decimals” settings to remove the decimals:

{"percentage":true,"suffix":"%","progressBar":true,"totalsType":"average","decimals":0}

Let me know how this works out.

Alexander

[DCH]

I promise I tried that first! But somehow it worked this time……. 😉

Thanks!

[Alexander Bautz]

I’m glad it worked out!

Alexander

[Author]

Posts