comparing text instead of numbers resulting in wrong sorting - InfoPath Dev
in

InfoPath Dev

comparing text instead of numbers resulting in wrong sorting

Last post 10-24-2013 02:04 AM by Arvid. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 10-24-2013 02:04 AM

    • Arvid
    • Not Ranked
    • Joined on 09-30-2013
    • Posts 4

    comparing text instead of numbers resulting in wrong sorting

    I have a form with lots of check and radio buttons which I summerize in several fields.

    At the end I have two totals, one for women and one for men.

    So far so good.

    Now I want the highest number to show in a different field, so I make a rule with a condition in the womenField and one in the menField to do that. ANd that works .... most of the times.

    if I have for example 5 and 8 it chooses 8.

    If I add 4 and the two fields become 9 and 12 it chosses 9????

    if I add something again and it becomes 10 and 13 then it is correct again.

    I thought it's because it checks the numbers not as a number but as text, so I chose for all the fields integer as datatype but that doesn't change a thing.

     

    Why is it that the condition womenField > menField does not render correctly?

     

    thank you 

    Arvid

     

     

     

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