Field Value Percentage but set to Display ONLY .xx - InfoPath Dev
in

InfoPath Dev

Field Value Percentage but set to Display ONLY .xx

Last post 11-27-2012 05:30 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-26-2012 10:18 AM

    Field Value Percentage but set to Display ONLY .xx

    I have looked all over and can't find a resultion to the following:

    FieldA - users should be able to enter only 2 whole #'s (e.g. 20).  The contents are to be displayed and used in other calculations as .20

    If I set the value to percentage, 2 decimal places but then div by 100, I get too many decimal places.

    If I round, it rounds to the next whole number, not the 2 decimal places.

    I have tried to set the value to whole number then create a rule that when field changes to div by 100. That's doesn't work.

    I know this is probably something simple, I just am not getting it today.

    Corrie

    Filed under:
  • 11-27-2012 05:30 AM In reply to

    Re: Field Value Percentage but set to Display ONLY .xx

    I don't think you can do both: (a) limit the user to only enter two digits (whole number) and then (b) store the same value as a decimal in the same field. InfoPath uses two different data types for each.

    You could have a text box where the user enters two digits (20) and a second node in the schema where you convert that (to .20) for use in calculatation. Would that work?

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.