5 Replies Latest reply on Jan 14, 2020 10:41 AM by Kelly McGrady

    Formatting percentages

    sajeel adnan

      Hi all,

       

      I am trying to format a measure that is a calculated field and a percentage.  Please see the screenshot below.  The last column in the view is what i need to fomat.  Currently it is formatted as a percentage; but I would like the parenthesis to show up for the negative numbers, like it is in the column before it, while still showing up in percentage form in the view.  I tried to add the parenthesis by formatting that measure as a custom number, but then the percentages show up in decimal form.  Can anyone help me with?  Any help would be greatly appreciated.

       

      regards,

      Sajeel Adnan