12 Replies Latest reply: Jun 7, 2016 2:49 PM by anya K. RSS

    Displaying negetive percentage values as (##%)

    Vladimir Komarov


      Hello all,

       

      I need to display negative percentage values in the chart in the (##%) format (as (5%), (10%) instead of -5%, -10%).

      Here is the default QV formatting:

      1.png

      using the '#,##0%' format string

       

       

      I thought displaying negative percentage values in parenthesis should be a trivial task and I've updated the chart with the following format string '#,##0%;(#,##0%)'.

      As a result values are displayed like:

      2.png

      I am not 100% sure how QV is using this format string, but it looks like it doubles "Show in percent %" option and divides values by 100 one more time (for negative values only).

       

      I was hoping somebody have more elegant solution instead of using (Var *100) option for negative values in my Expression....

       

      The closest one I've found is to use the '#,##0%;(#,##0)%' format string (% sign outside the parenthesis).

      3.png

      This display format is a bit un-orthodox, but at least the values are correct.

       

      Any other solutions/suggestions? I would appreciate a feedback.

       

      Best regards,

      Vladimir