https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/118597.aspxThu, 22 Mar 2018 19:59:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118597Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118597.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118597Put calculated values on the form that show the actual values (not formatted) so you can compare them. The formatting may be confusing the issue.https://www.infopathdev.com:443/forums/thread/118596.aspxThu, 22 Mar 2018 18:53:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118596jenielle0https://www.infopathdev.com:443/forums/thread/118596.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118596Good Morning Hilary! Both fields are configured exactly the same. Both are Data Type Decimal (double), formatted as Currency symbol $ English (United States), with the decimal set at 2 places, using a digit grouping symbol (,). The Split Total field is adding up 12 lines of split amounts and they are also formatted the very same. This is why I do not understand why this is happening. None of these fields contain text - they are all set as specified above. Any ideas? Thanks again for your help! Jenhttps://www.infopathdev.com:443/forums/thread/118595.aspxThu, 22 Mar 2018 15:07:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118595Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118595.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118595Is SplitTotal also a decimal? I'm assuming you have the data type on both of these fields set to decimal? Here's a sample form that uses the number function to compare a decimal to a text field, in case that's helpful (but I'd recommend setting the data type to SplitTotal to decimal). Save the attached file locally, right click & select design to open in design mode, then you can preview and try it out.https://www.infopathdev.com:443/forums/thread/118586.aspxWed, 21 Mar 2018 22:15:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118586jenielle0https://www.infopathdev.com:443/forums/thread/118586.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=118586Hello! I have an infopath form which is producing an error message on two fields which need to agree. One field is called InvoiceAmount, which the user needs to manually enter, and it is set as formatted currency, USD with 2 decimal places. Users can enter the whole number with or without decimals if there are no cents in the amount (ie 20 or 20.00). There is a second amount called SplitTotal which needs to agree with the Invoice Amount field. Essentially, the SplitTotal field is adding/summing several lines that the user can use to split the total mount of 20. The split amount must match the Invoice amount, but what is happening is the SplitTotal field is automatically placing the ".00" in the amount if the totals come to a whole number. So if the user entered the whole number and no decimals in the InvoiceAmount, the two fields are not matching. I have to anticipate that users will do this very (innocent) thing and encounter the same error. Is there a way to make the two fields agree if the amount entered is a whole amount, whether they just enter the whole number or the whole number with the two zeros after the decimal? Thank you for your help! Jen