Common Keys

The common keys section under Operators and Functions lists the operators and symbols most frequently used in mathematical expressions.

Button

Syntax

Definition

../../../../geohelp/image/adddummy.jpg

DUMMY

Inserts the constant DUMMY at the cursor. This constant is translated to the appropriate data type by the math engine.

../../../../geohelp/image/Freq_001.jpg 

/

Division

../../../../geohelp/image/Freq_002.jpg 

*

Multiplication

../../../../geohelp/image/Freq_003.jpg 

-

Subtraction

../../../../geohelp/image/Freq_004.jpg 

+

Addition

../../../../geohelp/image/Freq_021.jpg 

(

Open Parenthesis

../../../../geohelp/image/Freq_005.jpg 

%

Calculates the modulus (remainder) of a division operation. Examples:

11%3 = 2 (11÷3 = 3 remainder 2)

12%4 = 0 (12÷4 = 3 remainder 0)

../../../../geohelp/image/Freq_006.jpg 

sqrt(x)

Calculates the square root of x.

../../../../geohelp/image/Freq_007.jpg 

**

Exponent: Raises a value to the power of another. For example:

2 ** 3 = 8 (2 to the power of 3)

../../../../geohelp/image/Freq_022.jpg 

)

Closed Parenthesis

../../../../geohelp/image/Freq_019.jpg 

e

Calculates the natural logarithm of x (base e).

../../../../geohelp/image/Freq_020.jpg 

../../../../geohelp/image/Freq_pi.jpg

The constant value of π is approximately 3.14159265358979.

../../../../geohelp/image/equalssign.jpg

=

Equality: Tests if two values are equal in expressions or assigns values in declarations.

@Var#

Temporary Variables Names. Represents temporary variable names used during runtime and are not saved in the database.

Application Notes

Rules for Using Dummy (Placeholder) Values

Dummy (or placeholder) values are treated differently by some operators than by others.

  • Logical operators (!,>, <, >=, <=, ==, !=, &&, ||) treat DUMMY values as if they were regular numbers or the boolean TRUE. These operators do not check whether the value is a placeholder.

  • Mathematical operators (+, -, *, /, **, % etc.) check for DUMMY values. If any operand is a DUMMY, the result will always be a DUMMY.