InfoPath 2010

Re: How do I compare 2 fields (gretaer then) as numbers

daniweb — Mon, 03 Dec 2012 07:39:13 GMT

You rock!

your solution works. when I'm applying the decimal-compare - it gives me an error when clicking on the button: "some rules were not applied, unspecified error" .

10x a lot.

Re: How do I compare 2 fields (gretaer then) as numbers

Jimmy — Mon, 03 Dec 2012 04:04:16 GMT

You should be able to do this:

number(dfs:dataFields/my:SharePointListItem_RW/my:FirstValue) > number(dfs:dataFields/my:SharePointListItem_RW/my:SecondValue)

But have you experienced any issue with the msxsl:decimal-compare? I would expect it to work as you need it to.

How do I compare 2 fields (gretaer then) as numbers

daniweb — Sun, 02 Dec 2012 11:26:33 GMT

Hi All,

I have 2 text-boxes(actually they are 2 drop-downs from that are being filled from lists, but it doesn't matter).

After I click a button, I want to compare these 2 text-boxes but a number comparison not a string-compare.

when I click the button, add a rule I can compare these text-boxes but the result is a string compare, even when I click the expression I see that it is:

msxsl:decimal-compare(dfs:dataFields/my:SharePointListItem_RW/my:FirstValue, dfs:dataFields/my:SharePointListItem_RW/my:SecondValue) >= 0