Allow (rounding) differences - InfoPath Dev
in

InfoPath Dev

Allow (rounding) differences

Last post 04-20-2011 07:46 AM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-20-2011 06:59 AM

    Allow (rounding) differences

    Dear all,

    in a infopath form which I created is there at the end a quick check if the amount in column A is the same as the eventual total sum.

    The only disadvantage is that the amount in column A is a fixed amount, for example: 150,00 EUR

    To calculate to total amount, a few steps go by, but at the end they have to take X-percent of the amount. For example:  600,36 EUR x 25% = 150,09 EUR
    Due to the rounding difference, the total sum at the end is not always exact equal...

    What happens next? If those 2 amount are not equal to each other, the button submit has been disabled...

    Therefore I would like to know if there's a possibility to allow a certain margin of about 1 EUR? Otherwise I would receive a lot of complaints ;-)

     

    Thank you in advance for your replies!

    Regards,

    Niels

  • 04-20-2011 07:46 AM In reply to

    Re: Allow (rounding) differences

    In your conditional formatting on the Submit button, disable it on the conditions:

    actualAmount > expectedAmount + 1 OR

    actualAmount < expectedAmount - 1

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.