General

Re: round() function doesn't work well

edouard — Fri, 07 Jan 2011 07:22:14 GMT

It works, thank you guys so much.

Re: round() function doesn't work well

Jimmy — Fri, 07 Jan 2011 07:12:45 GMT

Try using div 10000 instead of * 0.0001. That should work better.

Re: round() function doesn't work well

Patrick Halstead — Fri, 07 Jan 2011 04:02:02 GMT

What's the precision (data type) for the field that is receiving the calculated results?

Is this all happening within InfoPath, or are you round-tripping the value to SQL and seeing the results change?

Re: round() function doesn't work well

edouard — Fri, 07 Jan 2011 01:59:22 GMT

any ideas for this? please help, this is urgent, it drive me crazy.

round() function doesn't work well

edouard — Thu, 06 Jan 2011 16:00:10 GMT

I was so confused.

I'm working on a project creating an InfoPath 2010 form which will submit to an SQL (2008 R2) database. Here's a curious situation. I have two values, I use the round function to restrict the decimal portion to four. Here's the basic calculation: round((@field1 / @field2) * 10000) * 0.0001. The data is valid sometimes.

I did a test: seting field1 to 1, set field2 to (1,2,3,4,5,6,7,8,9,10,11), the results are (1, 0.5, 0.333300000, 0.25, 0.2, 0.166700000, 0.1429, 0.125, 0.1111, 0.1, 0.090900000), these invalid were when field2 are 3,6,11.

Anyone have any ideas?