Analytics Center Operators¶
List of Operators¶
Operator |
Description |
Result Data Types |
Examples |
---|---|---|---|
+ (Text Concatenation) |
Concatenates two text values in that exact order. |
Text |
To return employee’s full name from [FirstName] and [LastName] columns: |
+ Add |
Adds two numbers or two currency amount, or adds a number of days to a date. |
The data type with the higher prededence. |
Two and a half days from hire date: |
- (Subtract) |
Subtracts two numbers or two currency amount, or subtracts a number of days from a date. |
The data type with the higher prededence. |
The number of products in stock after 10 have been taken out: |
* (Multiply) |
Multiplies two numbers, or a currency amount with a number. |
Number |
Price after 15% discount: |
/ (Divide) |
Divides one number or currency amount by another. |
Number |
Price after 50% discount: |
= (Equals) |
Compares the equality in value of two expressions. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. |
Boolean |
Employees named ‘John’: |
> (Greater Than) |
Compares if the value of the first expression is higher than the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. |
Boolean |
Products with more than 10 units in stock: |
< (Less Than) |
Compares if the value of the first expression is lower than the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. |
Boolean |
Products with less than 3 units in stock: |
>= (Greater Than or Equal To) |
Compares if the value of the first expression is higher than or equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. |
Boolean |
|
<= (Less Than or Equal To) |
Compares if the value of the first expression is lower than or equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. |
Boolean |
|
<> (Not Equal To) |
Compares if the value of the first expression is not equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. types are different. |
Boolean |
Products still available in stock: |