Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Best way to transform column data

I have a column of data that has mutliple formats for what is supposed to represent %, see below.  What is the best way to transform them to all be valid %.  Assume this may entail multiple transform steps?

0.91
0.788944
0.734365
0.719414
100
92.295
100
98.005
96.46
97.98
99.32
98.81
97.825
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    How about adding a new calculated column as

     

    =if([Column1]<1,[Column1],[Column1]/100)

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous

     

    How about adding a new calculated column as

     

    =if([Column1]<1,[Column1],[Column1]/100)
  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    By the way, to display the number as a percentage, you may use FORMAT or select Percentage format under Modeling tab.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      thanks. The challenge wasn’t formatting to percent. When I change formatting it shows some as 1000% and some as 100% because the raw data was 100 in some rows and 1 in others.