Keep if X.12 or X.123 leave as is, no rounding

[Former Member]

Hi,

I have been looking around for about an hour now and can not seem to find this exact question.

I have data from an XML file and sometimes the Price field has two digits after the decimal and sometimes 3

so most are 1.12 but now and then some are 1.123

I need to just keep them as is however no matter what I have tried so far the data gets either rounded or truncated.

I have tried ToText... no help

Any Ideas?

[Former Member · Accepted solution]

I found a way to do it in a formula:

If mid(mid(ToText"({Order.Price},3),InStr(ToText({Order.Price},3),".")+1,4),3,1) = "0" then

          "$" + ToText({Order.Price},2)

Esle

          "$" + ToText({Order.Price},3)

I was not able to Cut and paste the formula directly in here... I don't know why... so I had to type in the above.  Sorry If there is a typo.

Thx

Tim