The operators in table 1 can be used in formulas.
Table 1. Operators in ModelMuse Formulas
Operator |
Meaning |
Data Types |
Result type |
---|---|---|---|
|
|||
= |
equals |
real numbers, integers, Booleans, text |
Boolean |
<> |
not equals |
real numbers, integers, Booleans, text |
Boolean |
> |
greater than |
real numbers, integers, Booleans, text |
Boolean |
< |
less than |
real numbers, integers, Booleans, text |
Boolean |
>= |
greater than or equals |
real numbers, integers, Booleans, text |
Boolean |
<= |
less than or equals |
real numbers, integers, Booleans, text |
Boolean |
and |
and |
Booleans |
Boolean |
or |
or |
Booleans |
Boolean |
xor |
exclusive or |
Booleans |
Boolean |
not |
not |
Booleans |
Boolean |
mod |
modulus (remainder) |
integers |
integer |
div |
integer division |
integers |
integer |
^ |
raise a number to a power |
real numbers, integers |
real number |
** |
raise a number to a power |
real numbers, integers |
real number |
* |
multiplication |
real numbers, integers |
real number, integer |
/ |
division |
real numbers, integers |
real number |
+ |
addition or concatenation |
real numbers, integers, text |
real number, integer, text |
- |
subtraction |
real numbers, integers |
real number, integer |
|