Common Keys

The Common Keys section covers the operators and symbols that are used most commonly in math expressions.

Button

Syntax

Definition

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

DUMMY

At the cursor the constant DUMMY is added to the Expression. 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 Parentheses

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

%

Modulus (Remainder) of a division. For example:

11%3 = 2 (11/3 = 9 with remainder of 2)

12%4 = 0 (12/4 = 3 with remainder of 0)

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

sqrt(x)

Square Root

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

**

Exponent

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

)

Closed Parentheses

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

e

Natural logarithm

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

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

The constant 3.14159265358979

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

=

Equality

@Var#

Temporary Variable Names. These variables are using at run time 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.

The logical operators (!,>, <, >=, <=, ==, !=, &&, ||) do not check the value to see if it is a dummy and will function as if it were a number or TRUE.

The mathematical operators (+, -, *, /, **, % etc.) will check for dummy values and will ALWAYS return a dummy if any dummies are used in the calculation.

See Also: