2 Replies Latest reply on Mar 28, 2017 8:44 AM by Keith Drakeford

    Significant figures in a table

    anoop odedra

      Hi,

       

      I am trying to format a table of numbers with percentages to only show significant figures. I have managed to get most of the solution but am stuck on one bit. I have set the format of my measure to custom and the format as #.##% which means if the percentage is 90.10% only 90.1% will be displayed, or if the percentage is 95.48%, 95.48% will be displayed. The problem occurs when the percentage is 100% as that is exactly what I would expect to be displayed, but instead 100.% is displayed (with a decimal point). Is there a way to correctly display what I am after?

       

      Thanks

       

      Anoop