Rounding and Decimals in output

Hi ,

I have following data in column Field1 and want it to print in column Desired_Output. Please note my Feild1 is of Double data type

Field1

43.36275

1580.5988

2756.38083

490.52579

899.33922

14.73303

787.32983

43.4266

Desired_Output

1.581

2.747

491

899

787

How can i achieve it ?

Regards

Areeba

Output

Accepted answers

atcodedog05

Happy to help : ) @areeba

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

All comments

RolandSchubert

Hi @areeba ,

you can convert the column to a string data type using the formula ToString([Field1], 0, '.', ',') - you'll have a dot as thousands separator.

Best,

Roland

areeba

Hi @RolandSchubert ,

Thank you for replying but can you be more specific with the formula? This formula gives me error Type mismatch:String provided where a number is required.

Thanks

Areeba

RolandSchubert

The target field has to be a string data type. I've attached a sample.

Conversion.yxmd

areeba

Hi @RolandSchubert

Your sample has error itself what i am facing.

@atcodedog05 Can you please help ?

Thanks Areeba

RolandSchubert

Could you please provide a screenshot of the error? It runs without any problems in my environment.

areeba

Hi ,

Please find below the screenshot . One thing when i tried opening your sample it gave me warning that my organization is not having the version to which your sample has been created. Do you think this could be the reason ?

areeba

Hi @atcodedog05

I have notice one thing when i applied this solution.

It is giving me correct result if output is 6.214 but if the output is 6.210 then it is returning 6.12 or if the output is 5.20 then it results as 5.2

why is it omitting 0 as a last digit? what should i do to fix this?

Regards

Areeba

atcodedog05

Hi @areeba

Its caused because of rounding. If you fixed decimal datatype instead of double it will always have fixed number decimal digits.

Hope this helps : )

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703