Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

numeric value (double) with many decimal 0s?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin Eckart - 21 Apr 2006 14:42 GMT
Hi guys,

I have a form containing many different prices. At the end there is a field
which sums up all of them and gives you the total price.
All fields are data type double. If I sum up a few of them like 0.45, 0.45,
0.40 and 0.95 I get this as result: 2.600000000

Often times I even get 2.6000001 or so. I know that I can format the number
in the text box of the total price but this does not modify the xml. So, any
suggestions how to get rid of the many decimals (most of them being 0) so
that the above gets displayed like "2.6"?

Thanks to all of you,

Martin
S.Y.M. Wong-A-Ton - 21 Apr 2006 15:59 GMT
Search this newsgroup for a post with the title "Incorrect results in
Infopath calculation - might be a bug?". There Bojana Marjanovic [MSFT]
explained why this occurs.
---
S.Y.M. Wong-A-Ton

> Hi guys,
>
[quoted text clipped - 11 lines]
>
> Martin
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.