OK, so I'm working in Infopath 2007.
Is there a way, without custom code, to round a number to say two decimal
places?
I've got a field (A) that is set to be a two decimal place number. When I
run a formula and store the result there, it rounds and displays the number
properly. BUT if I then try to use field (A) in another calculation, the
calculation is using the actual value in (A) vice what is displayed.
Hopefully I explained that clearly.
In Excel, I can "roundup" any number, and specify how many decimal places I
want. What gives Infopath?!?!?!
Thanks for any guidance (even if I have to use code).
--me
Clay Fox - 04 Mar 2008 22:15 GMT
You could probably use substring functions to truncate your decimal places.

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> OK, so I'm working in Infopath 2007.
>
[quoted text clipped - 14 lines]
>
> --me
Greg Collins - 04 Mar 2008 22:52 GMT
round(my:number * 100) / 100

Signature
Greg Collins
Microsoft MVP
Visit Braintrove at http://www.braintrove.com
Visit InfoPathDev at http://www.infopathdev.com
Clay Fox - 04 Mar 2008 22:58 GMT
Cool, much more eloquent!
Thanks Greg.

Signature
Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum
> round(my:number * 100) / 100