Forum Discussion

0xygen27's avatar
0xygen27
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Percentage automatically multiplies x100

Hello all,   I want to just place a percentage sign at the end of my data, but when I change from decimal number to percentage my data is multiplied by 100. So 3,4 = 340%. I don't want this, I just...
Show and Tell
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi 0xygen27

     

    A genuine percentage is actually a number between 0 and 1.

     

    So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

     

    Why not divide your number by 100 and then format it as a percentage?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi 0xygen27,

    Why so you divide 50 columns at once? Could you please share more details? 

    If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

     

     

     

    Best Regards,
    Angelia

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi 0xygen27

 

A genuine percentage is actually a number between 0 and 1.

 

So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

 

Why not divide your number by 100 and then format it as a percentage?

  • 0xygen27's avatar
    0xygen27
    Icon for Advocate II rankAdvocate II
    9 years ago

    HI Phil_Seamark,

    I totally forgot about the 0-1, thanks for your reply :)

  • 0xygen27's avatar
    0xygen27
    Icon for Advocate II rankAdvocate II
    9 years ago

    Phil_SeamarkIs there a way to divide 50 colums at once? 

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi 0xygen27,

      Why so you divide 50 columns at once? Could you please share more details? 

      If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

       

       

       

      Best Regards,
      Angelia

      • 0xygen27's avatar
        0xygen27
        Icon for Advocate II rankAdvocate II
        9 years ago

        I had a colum with percentages without the % mark, I just wanted to place a % mark behind it. It was a Opendata file, but it was just a testing file and I moved away from the file, because it wasn't good enough. Thanks for your help though :)

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      What is your source?  Are you using SQL