Decimals in Column Totals

Forums vLooup for SharePoint Decimals in Column Totals

This topic contains 5 replies, has 2 voices, and was last updated by  Alexander Bautz 2 months, 1 week 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"}
  • #15068

    Alexander Bautz
    Keymaster

    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

  • #15070

    DCH
    Participant

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

    Thanks!

  • #15076

    Alexander Bautz
    Keymaster

    I’m glad it worked out!

    Alexander

You must be logged in to reply to this topic.