Basic Elements of an Expression
There are five basic elements of an expression:
Operands
Operands are values or text that the formula operates on. These may be actual values such as "4", or field names (including text or numeric fields).
Operators
Operators are mathematical symbols, text characters, or logical statements that indicate to the application what must be done with the operands in a formula. The scripting operators are similar to those in Microsoft Excel.
There are several types of operators:
• Arithmetic Operators
• Assignment Operator
• Logical Operators
• Comparison Operators
• Concatenation Operator
Parentheses
You can use parentheses in complex formulas to determine the order in which you want formulas calculated. Operations within parentheses are executed first.
Example of Nested Parentheses
(Field + Field * (Field - Field)/ Field)
Functions
Functions are snippets of code that perform specific tasks. Use them in expressions to manipulate data or filter records. The functions available are similar to the functions in Visual Basic.
Statements
Statements are standalone elements used to form programs. Statements often call functions and include internal components such as expressions.
Last modified date: 10/22/2024