Invalid data error with text box calculations - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Invalid data error with text box calculations

Last post 03-19-2009 05:54 AM by pablavo. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-19-2009 05:54 AM

    Invalid data error with text box calculations

    Hi there,

     This is a short one and I hope someone has come accross this as well.

    I have a text box (txtAmount) which has a calculation for its value.  The calculation  multiplies two fields together.

    One field stores a number of days (Days) worked by someone.  This is stored as a decimal.  The other stores Currency amounts. (Costs).  Sometimes depending on the Currency amount I get an "Invalid Data' error around txtAmount.  For example, if (Days) has the value 1.2 and it multiplies £471, I get the error.  If (Days) is 1.75, I don't get the error.

    The calculation is this:

    @Days * @Cost

    Does anyone know why this is and if there's anything I need to do to prevent this error.

     Thanks for any help.

    ____________________________________

    Take a deep breath phsssssssssss
Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.