Inconsistent rule behaviour when value has 2 decimal places

S

stuartwhiteford

I have an InfoPath 2007 form with the following fields: -

Subtotal
Delivery
Tax
Total

There are rules on both the Subtotal and Delivery fields that re-calculate
the tax (based on 15% rate) when either of the values change. Additionally
there is a button on the form that retrieves that form data from a web
service. My understanding is that when this button is pressed and the web
service call is made, the rules on these fields won't fire (because a user
has not changed them). This is the behaviour I expect.

The Subtotal field is calculated based on the sum of a field in a repeating
section. Depending on what the value is in the repeating section seems to
determine whether the rule fires.

The value in the database for the Tax field is always £5.00.

If I change the Unit Price (in the repeating section) to £24.99 the Tax
field recalculates.
If I change the Unit Price (in the repeating section) to £25.00 the Tax
field does not recalculate and displays £5.00.
If I change the Unit Price (in the repeating section) to £24.51 the Tax
field recalculates.
If I change the Unit Price (in the repeating section) to £24.50 the Tax
field does not recalculate and displays £5.00.

Why does this happen?

Stuart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top