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.

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

Spot on!

 

Didn't work because it was a measure and not a value.

 

Got it now, though this will only work if the total of your percentages is equal to 1. Otherwise, you get 100% everywhere :)

 

Thank you so much Chris99 for your kind, sharp and top helpful assistance on all my posts :)

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

Arcturus

 

Glad to help. I'll be needing the forums plenty in the months to come, so hopefully I'm building up some karma points :smileyhappy: