Forum Discussion

Arcturus's avatar
Arcturus
Icon for Helper I rankHelper I
8 years ago
Solved

Percentages displaying as decimals

Hi all,

 

Percentages, taken from a column turned into Percentage Type, currently display as decimals in the report view (i.e., 0,87 instead of 87%).

 

How do I correct it in a "cleaner" way than duplicating the source column, multiplying by 100 and adding % at the end.


Thanks,

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    In the data model, click on the column and then go to the Modeling tab and click the "%" format button.

10 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    In the data model, click on the column and then go to the Modeling tab and click the "%" format button.

    • Shethp's avatar
      Shethp
      New Member
      6 years ago

      Hello,

      I did change the format from Decimal Number to Percentages in the Query Editor Window. However, it still shows Decimals on the visualization. Thoughts?

    • Arcturus's avatar
      Arcturus
      Icon for Helper I rankHelper I
      8 years ago

      Wonderful, thank you so much - did not even know about this wonderful tab!

      • Chris99's avatar
        Chris99
        Icon for Advocate III rankAdvocate III
        8 years ago

        Alternatively if you didn't want to set your data field to be treated as a percentage globally, then on you chart you can right click on the Value, and at the bottom of the context menu there is Show value as...

         

        On here there should be some percentage options.