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...
  • 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.

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.

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

        Thanks, though for some reason I can't find this option.

         

        Am I clicking on the right item? (cf. pictures below)