Policy Automation for Service

Get Involved. Join the Conversation.

Topic

    Scott Heidenreich
    Using mathematical operators as text values
    Topic posted June 3, 2019 by Scott HeidenreichGold Medal: 3,500+ Points 
    29 Views, 2 Comments
    Title:
    Using mathematical operators as text values
    Summary:
    How to use mathamatical operators
    Content:

    I have a text attribute "the choice" for which a valuelist of 0, 1, 2, or 3 can be chosen.

    When I use  the choice = "0" in an excel rule - it throws an error. 

    I also have another text attribute that has ranges of numbers as choices in a value list (>1m, >.7m -1m, etc.)

    When I use the attribute = ">1m" in an excel rule it throws an error. 

    Why is this happening?

    Version:
    18D

    Comment

     

    • Brad Tuckett

      Is this a text attribute or a text value list attribute?  If you have defined a text value list with those values, and "the choice" is of that value list type, then the rules will work.

       

    • Scott Heidenreich

      Thank you for your response. It seems to be working today. Yesterday, it was throwing a "Cannot use two operators in the same condition" error message, even though the rule was written exactly as you  show in your image above, and I didn't change the rule between yesterday and today.