General

Re: How to truncate a decimal field

deppen — Thu, 31 Mar 2011 18:07:15 GMT

Qwerty,

That is just what I needed and it works perfect.

Thank you for your help!

Re: How to truncate a decimal field

qwerty — Thu, 31 Mar 2011 17:36:13 GMT

Hi deppen. Use this rule on your decimal field:

If The Expression: contains(string(decimalField), "."):

Set a field's value: decimalField = number(substring(string(decimalField), 1, string-length(substring-before(string(decimalField), ".")) + 2)).

Hope this helps!

How to truncate a decimal field

deppen — Wed, 30 Mar 2011 16:04:04 GMT

Hi. I am using Infopath 2003. I have a decimal(double) field in a form with one decimal place. I’m looking for a way to truncate the field instead of having Infopath round the value in the field. For example, if a user enters 4.899 in the field, the field becomes 4.9. I want the value of this field to remain 4.8. Any help you can offer is appreciated. Thank you!