Decimal to read correctly

Hi Team,
I have a data sets which i need to convert this numerical as per below

Description14

27.5

25.01

30 to read as "30.0" , 27.5 to read only as "27.5" and 25.01 to read as "25.01" - how can we set a formula for decimal integers to read it correctly ?

Thanks so much !

Regards,

Guru

Topic of Interest

Accepted answers

jrgo

@Inactive User

Only way is if that field is converted to a STRING data type where you can customize the output. If that would be acceptable, the expression below used to create a new field would produce the desired format.

REGEX_REPLACE(TOSTRING([Description14], 2), '^(.+)0$', '$1')

Hope this helps!

Jimmy

Emil_Kos

Hi @Inactive User,

Now I know that I didn't understand your initial question correctly.

I believe @apathetichell and @jrgo got valid points in order to how you can tackle this problem.

One more question to you @Inactive User what is the reason that you want to highlight the data in this way?

All comments

Emil_Kos

Hi @Inactive User,

with your example, you can just change the data type to double and it will work.

If you will get a coma instead of a dot it would be more complicated but I have show both solutions in the workflow.

Replace char.yxmd

unknown

Hi @Emil_Kos

Thanks for your response - I have a huge data set will have to set a formula which identifies below scenario's.
Numeric 30 to read as "30.0" and

no changes if data set shows as "27.5" to read as 27.5 and

25.01 to read it as 2 decimal points... Please advice.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703