Operators

All of the operators supported in Panorama formulas are listed below:

- - -- The - operator subtracts the numeric value on the right from the numeric value on the left.
- * -- The * operator multiplies the numeric value on the left by the numeric value on the right.
- / -- The / operator divides one numeric value by another.
- \ -- The \ operator performs integer division.
- ^ -- The ^ operator raises a number to a power.
- + -- The + operator works differently depending on the type of operands used with it. If both operands are numeric, it does numerical addition. If either operand is text the + operator concatenates (joins together) the two operands.
- < -- The < operator compares two values to see if the first value is less than the second value.
- <= -- The <= operator compares two values to see if the first value is less than or equal to the second value.
- <> -- The <> operator compares two values to see if they are different.
- = -- The = operator compares two values to see if they are the same.
- > -- The > operator compares two values to see if the first value is greater than the second value.
- >= -- The >= operator compares two values to see if the first value is greater than or equal to the second value.
- and -- The and operator returns true if both operands are true.
- beginswith -- The beginswith operator returns true if the value on the left starts with the value on the right, false if it doesn't.
- contains -- The contains operator returns true if the value on the left contains the value on the right, false if it doesn't.
- containsword -- The containsword operator returns true if the text contains a specified word, false if it doesn't.
- endswith -- The endswith operator returns true if the value on the left ends with the value on the right, false if it doesn't.
- like -- The like operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- match -- The match operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- matchexact -- The matchexact operator checks to see if the text on the left matches the wildcard pattern specified on the right.
- mod -- The mod operator computes the remainder (modulo) after integer division.
- not -- The not operator reverses a boolean value.
- notcontains -- The notcontains operator returns true if the value on the left does not contain the value on the right, false if it does.
- notmatch -- The notmatch operator checks to see if the text on the left does not match the wildcard pattern specified on the right.
- notmatchexact -- The notmatchexact operator checks to see if the text on the left doesn't match the wildcard pattern specified on the right.
- or -- The or operator returns true if either operand is true, or false if both are false.
- regexmatch -- The regexmatch operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
- regexmatchexact -- The regexmatchexact operator checks to see if the text on the left matches the regular expression on the right (see Regular Expressions).
- soundslike -- The soundslike operator compares two words to see if they "sound like" each other.
- Text Funnels -- Text funnels strip off the beginning and/or end of a text string based on your specifications.
- xor -- The xor operator returns true if one of the two parameters is true, false if neither or both are true.