General

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Hilary Stoupa — Fri, 25 Feb 2011 19:16:11 GMT

Wonderful.

A little unsolicited advice -- if this form is not in production (that is, no one has started using it yet) you should consider re-naming your fields. Formulas, conditional formatting, rules -- they are all so much easier to deal with when your fields have names like "Quantity" and "Price" instead of field12345. And, if you put this form in production like this and need to make a change in 6 months, you'll make yourself batty trying to remember what field25 is.

Also, so you know for the future, that error message was basically saying "I think you are telling me about a field you'd like me to select, and I can't find it". Everything between the --> and the <-- was what it was trying to evaluate. That's how I knew (aside from looking at the text you'd pasted) what the error was, since we use "/" in our XPath to select a field...

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Lyndsey — Fri, 25 Feb 2011 19:08:38 GMT

Awesome, it works!!!

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Hilary Stoupa — Fri, 25 Feb 2011 19:04:21 GMT

Make sure you have a space before and after the "/" symbol (or type in div as per Jimmy's example, again with space before and after).

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Lyndsey — Fri, 25 Feb 2011 18:58:54 GMT

I get this error:

The expression is not a node-set.
ceiling(-->(((field16*1.15)+field20)*field25)<--/5)*5

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

tafavorite — Fri, 25 Feb 2011 17:36:06 GMT

Heres what I got to work

ceiling((((field16 * 1.15) + field20) * field25) / 5) * 5

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Lyndsey — Fri, 25 Feb 2011 17:22:13 GMT

like this? ceil((field16 * 1.15) +field20 ) *field25div 5) * 5

I get an error like this.

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Lyndsey — Fri, 25 Feb 2011 17:20:12 GMT

Do I put this before or after the the fist equation? Sorry, VERY new to infopath!

Re: Round up to nearest $5 in InfoPath 2007 - Rush!!

Jimmy — Fri, 25 Feb 2011 16:33:21 GMT

ceil(value div 5) * 5

Round up to nearest $5 in InfoPath 2007 - Rush!!

Lyndsey — Fri, 25 Feb 2011 15:11:17 GMT

I am creating a form and in one field I already have a function/calcualtion that includes other fields ((field16 * 1.15) + field20) * field25

I need this calculation to round up to the nearest $5. How do I need to write this formula to get that result??