User Guide
×
Menu
Index

Other Mathematical and Comparison Functions

 
When working with numeric values, expressions allow us to perform basic arithmetic operations. We can add (+), subtract (-), multiply (*), and divide (/) numbers. To raise a number to a given power, use a caret symbol (^). Moreover, you can obtain absolute value (Abs) and round figures to a given number of decimal places (Round). See some examples below (Invalid Expression error messages are caused by not handling missing values).
 
1. Add
 
2. Subtract
 
3. Multiply
 
4. Divide
 
 
5. Raise to a given power
 
 
6. Absolute value
 
 
7. Round
 
 
In cases that require true/false results, there is also a set of operators that allow comparing two figures. The list includes: == (equal), != (not equal), >, <, >= and <=.
 
Each can also be used to compare strings, for example, to check if two strings are equal.