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.

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)

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

        What version of Desktop are you running? I've got Version: 2.55.5010.641 64-bit (February 2018)