Forum Discussion
Converting several columns using a unit set
Hello,
I've got several columns that need to be converted using units. For example, I've got a lot of columns with data in meters, but I want to have feet. Also, I've got a lot of columns with tasks duration in a decimal number that must be multiplied by 24 to represent hours.
I would like to have a constant multiplier / conversion factor for each unit type (distance, duration, etc.) and apply it to several columns at once when preparing the data.
Anybody comes with another idea rather than copy&paste the function for each column? Thanks!
Hi Anonymous,
You should create calculated columns and you will achieve what you want.
Refer this link to know more.
Prateek Raina
4 Replies
Hi Anonymous,
You should create calculated columns and you will achieve what you want.
Refer this link to know more.
Prateek Raina
Thank you prateekraina,
I already explored this possibility and I'll still require a lot of work, since I've got +100 columns that need some kind of conversion.
I think I'm looking for a way to "categorize" the columns that doesn't exist yet... It'll be great to be able to create "unit sets" that you can use to automatically convert currencies, measurements, etc...
You are right. That feature is not currently available out of the box.
You need to convert them manually as of now.
Prateek Raina