InfoPath Dev

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!

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!

Qwerty, 

That is just what I needed and it works perfect.

Thank you for your help!