https://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/119171.aspxFri, 01 Jun 2018 20:27:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119171ttrotman0https://www.infopathdev.com:443/forums/thread/119171.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119171Perfect! Thanks Hilary. Your help is invaluable!!https://www.infopathdev.com:443/forums/thread/119170.aspxFri, 01 Jun 2018 19:16:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119170Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119170.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119170Ok - the form2 sample I posted probably does what you need in those cases, right? Except for the edge case bug where the decimal is >= .95, in which case instead of changing from 21.95 to 22.00, it changes to 21.10? Because if I enter 20.8442, I get 20.80 in that form sample. Here's a copy with the >= .95 bug fixed.https://www.infopathdev.com:443/forums/thread/119169.aspxFri, 01 Jun 2018 19:06:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119169ttrotman0https://www.infopathdev.com:443/forums/thread/119169.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119169Ok. I can see where I got unclear. My apologies. It's true that I want it to display with two decimals. And it's also true that what I have works to do that. What I still need is for the final price to be rounded to the nearest 100th, I believe. So when I said I needed 21.9279 to turn into 21.90, I was saying I wanted a number to round to the nearest 0 or 5. Another example would be 20.8442 turning into 20.80. I hope I didn't further confuse.https://www.infopathdev.com:443/forums/thread/119167.aspxFri, 01 Jun 2018 18:46:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119167Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119167.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119167Here's what you said in your initial post: "... it calculates to 21.9279 I need that to turn into $21.90" - if all you really want is to display with two decimals, the formatting you said you have set up should already do that. I'm obviously not understanding what you are trying to do. Attaching a file with a text box w/ formatting set, just in case that's where the confusion is.... feel free to attach your form under the options tab if that might help me understand the issue.https://www.infopathdev.com:443/forums/thread/119166.aspxFri, 01 Jun 2018 17:50:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119166ttrotman0https://www.infopathdev.com:443/forums/thread/119166.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119166Thank you, but I think IP is doing the math incorrectly. Wouldn't 25.972 equal 25.97? Instead, the form is setting the number to 25.10. Would you happen to know how I would set up the math?https://www.infopathdev.com:443/forums/thread/119146.aspxThu, 31 May 2018 16:30:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119146Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119146.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119146Here's a sample that may help - save locally, right click & select design. You'll see in my sample, I'm not using a calculated default, but I think this approach will still work w/a calc'd default since the conditions should prevent any rule looping from resetting the field w/ the rules on it.https://www.infopathdev.com:443/forums/thread/119140.aspxThu, 31 May 2018 15:08:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119140Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119140.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119140I'm a math dunce and didn't realize that you wanted the last decimal to round, and thought the issue was just related to displaying only two decimal points! I'll see if I can figure out a way to do this later today, I'm guessing we can use substring functions....https://www.infopathdev.com:443/forums/thread/119138.aspxThu, 31 May 2018 13:11:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119138ttrotman0https://www.infopathdev.com:443/forums/thread/119138.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119138I'm displaying it in a text box. The format is currency and 2 decimals.https://www.infopathdev.com:443/forums/thread/119132.aspxWed, 30 May 2018 21:04:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119132Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119132.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119132Wonderful! Is the data type of the field decimal? Are you displaying the data in a text box or in a calculated value?https://www.infopathdev.com:443/forums/thread/119131.aspxWed, 30 May 2018 20:51:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119131ttrotman0https://www.infopathdev.com:443/forums/thread/119131.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119131I just need to display it that way in the form. So I guess if there's another route I can take, I'll take it.https://www.infopathdev.com:443/forums/thread/119124.aspxWed, 30 May 2018 17:15:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119124Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119124.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119124Do you actually need to round this? Or can you just display as the nearest 100th in the form?https://www.infopathdev.com:443/forums/thread/119119.aspxWed, 30 May 2018 14:08:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119119ttrotman0https://www.infopathdev.com:443/forums/thread/119119.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=119119Hey all, I'm trying to do some math in my form that allows me to calculate money. I'm actually calculating PayPal's fees. It's 2.99% per charge, plus $.30. I do that like this: sum(MealTotal) * 2.99 / 100 + .30 So for $21.00, it calculates to 21.9279 I need that to turn into $21.90. So I tried this: round(sum(MealTotal) * 2.99 / 100 + .30 + MealTotal * 100) / 100 Which returned this: $21.01 Can anyone tell me that right code to input into the form? Thanks in advance.