comparing text instead of numbers resulting in wrong sorting

Arvid — Thu, 24 Oct 2013 09:04:30 GMT

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

General

comparing text instead of numbers resulting in wrong sorting