My data set is coming as 54834 -32509 1 And I need it to read 548.34 -325.09 1.00

Adding Decimals to amounts

ElizabethT

My data set is coming as

54834

-32509

And I need it to read

548.34

-325.09

1.00

Datasets

Accepted answers

CharlieS

Here's an expression that can be used in a Formula tool to string-edit the input to achieve the desired result as a string:

Left(PadRight(tostring([Input]),3,'0'),
Length(PadRight(tostring([Input]),3,'0'))-2)
+"."+
Right(PadRight(tostring([Input]),3,'0'),2)

If you'd like to output this as a Fixed Decimal field, the attached example shows how you can add a "tonumber(' function and format the field accordingly.

20190926-StringtoFixedDec.yxmd

All comments

MarqueeCrew

That last one is odd.

[amount]/100

Is a formula that would work. You can make it conditional. If the only values not to divide by a hundred are those less than a hundred or other rule.

IIF([amount]>100,[amount]/100,[amount])

Cheers,

Mark

CharlieS

Here's an expression that can be used in a Formula tool to string-edit the input to achieve the desired result as a string:

Left(PadRight(tostring([Input]),3,'0'),
Length(PadRight(tostring([Input]),3,'0'))-2)
+"."+
Right(PadRight(tostring([Input]),3,'0'),2)

If you'd like to output this as a Fixed Decimal field, the attached example shows how you can add a "tonumber(' function and format the field accordingly.

20190926-StringtoFixedDec.yxmd

ElizabethT

That worked perfectly!

Thanks so much!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167