The following Operators can be used in expressions:
Arithmetic Operators
Using the following arithmetic operators you can make any type of calculation:
| + | addition |
| - | subtraction |
| * | multiplication |
| / | division |
| \ | integer division |
| % | the remainder after division of integers |
| ^ | exponentiation |
| ( | opening parenthesis |
| ) | closing parenthesis |
| : | time operator, multiplies the left operand with 60 and adds the right operand |
If you would like to add the race number and the year of birth and multiply the result with two, use the following expression:
([Bib] + [Year]) * 2
Comparison Operators
Use the following comparison operators to compare two values:
| < | less than |
| > | greater than |
| = | equal |
| <> | not equal |
| <= | less than or equal to |
| >= | greater than or equal to |
Logical Operators
Using logical operators, you can combine two conditions, for example in a Filter. The following operators are available:
- OR (At least one of the values is true)
- XOR (Must be one OR the other, cannot be both)
- AND
Array Operators
- IN
- NIN (NOT IN)
If the Data field is IN or is NOT IN the text string, multiple values can be separated by commas.
Examples:
[Contest] IN "2,4,8-10"
[Lastname] NIN "Smith,Doe"