Conditional Statement not having expected behavior
I created a conditional statement for a custom column. I have two sets of columns I'm using to determine the custom column's value.
IF (Installation Status = True) & (Version >= 8.2.6) then the custom column called Protected will be True.
However, for all the records where Version is 8.2.11 and such the column Protected is showing as False. My intuition is telling me this issue has something to do with comparing characters? But I'm not exactly sure how to resolve this.
Any suggestions or advice would be helpful. Thanks in advance for your expertise and time!
Hi @skedis - your intuition is correct. When Alphanumeric ordering occurs the 6 is greater that 11 because the 6 is compared to the first character. I would suggest trying to format the number by adding leading zeros. For example, convert from "8.2.11" to "08.02.11". Try using: