Forum Discussion
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...
Anonymous
How about adding a new calculated column as
=if([Column1]<1,[Column1],[Column1]/100)
Anonymous
How about adding a new calculated column as
=if([Column1]<1,[Column1],[Column1]/100)