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.**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.