Formatting % with the sign

• AntonyO

  Mr or Mrs. 500

  Points: 522

  More actions

  June 18, 2019 at 2:50 pm

  #3654793

  Hi,

  I need to format a field in this way: +/-#%

  Ex:

  -0.21  I want to display - 0%

  5.3  I want to display + 5%

   

  I tried this format : + ##0"%";- ##0"%";

  But for -0,21 I have + 0% (instead of - 0%). Is it a way to preserve the sign?

  Thank you

   

   

   

   

  • This topic was modified 4 years, 10 months ago by  AntonyO.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  June 19, 2019 at 3:10 pm

  #3655307

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Y.B.

  SSChampion

  Points: 11642

  More actions

  June 19, 2019 at 3:48 pm

  #3655327

  Deleted comment as I realized this was for Reporting Services.

  • This reply was modified 4 years, 10 months ago by  Y.B.. Reason: Wrong topic

  ---

  SELECT quote FROM brain WHERE original = 1
  0 rows returned

• Thom A

  SSC Guru

  Points: 99126

  More actions

  June 19, 2019 at 4:06 pm

  #3655347

  SSRS uses the same formatting codes as Excel does. If you need different styles for positive and negative values then you use a ; to separate the 2. So for this you want: + 0.00%;- 0.00%. This works on a random Sandbox report I had:

  

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk