Decimals in Column Totals

Welcome Forums vLooup for SharePoint Decimals in Column Totals

This topic contains 2 replies, has 2 voices, and was last updated by  DCH 4 days, 14 hours ago.

  • Author
    Posts
  • #14981

    DCH
    Participant

    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!

  • #14987

    Alexander Bautz
    Keymaster

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

    Alexander

  • #14990

    DCH
    Participant

    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"}

You must be logged in to reply to this topic.