Hi all - I thought that woudl be simple but i have spent some time looking for an answer I have the folowing data that comes in .2 1.2 50.22234555 75 but want the decimal to be fixed .002 .12 .52223455 .75 I have tried Regx and a formula but can't seem to get the result needed Thank yo

decimal places

Arkouda

Hi all - I thought that woudl be simple but i have spent some time looking for an answer

I have the folowing data that comes in

1.2

50.22234555

but want the decimal to be fixed

.002

.12

.52223455

.75

I have tried Regx and a formula but can't seem to get the result needed

Thank yo

Preparation

Accepted answers

chuckleswk

You can use the formula tool and create a new field with a fixed decimal of 8.6 and divide the “Bonus %” by 100. That should give you the results that you want.

All comments

Qiu

@Arkouda

I am sorry but I have failed to see a patern here.

.2 --> 0.002

1.2 --> 0.12

What makes the above having difference?

Arkouda

Hi Qui

I need to show all values leading by a decimal

Current data comes in as mixed

1.2

50.22234555

.12

but need the the values to be lead by a decimal like below

.002

.12

.52223455

.75

Qiu

@Arkouda
So your data coming in a mixed format.

you want them all to be converted to be in a format that is leading by a decimal point?

so still what is the difference below

.2 --> 0.002

1.2 --> 0.12
Can you give us the logic here, explaining how that each numer gets converted.

Arkouda

Correct want all values to lead by a decimal but needs to be six places following the decimal

See below as current data comes through (input > desired)

Bonus %
Input Data	Desired Output Data
90	.090000
90	.090000
90	.090000
9.90390733904294	.090390
9.52380952380952	.095238
9.52380952380952	.095238
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.5	.095000
9.47885986756895	.094788

chuckleswk

You can use the formula tool and create a new field with a fixed decimal of 8.6 and divide the “Bonus %” by 100. That should give you the results that you want.

Qiu

@Arkouda
Now it is very clear.

As suggested by @chuckleswk , Lets use the format of Fixed Decimal.

New Workflow2A.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167