Guidelines for Specifying Derivation Formulas
The derivation formula provides the calculation for determining the value of a derived field. When specifying a derivation formula, follow these guidelines.
A simple field can be derived from:
• Other simple fields, including other derived fields
• Aggregates of table field columns (cannot be derived directly from a table field column)
• A table field column can be derived from other columns in the same table field. A table field column cannot be derived from a simple field or aggregate value.
• You can use arithmetic operators, aggregates, and constants in derivation formulas, as explained in the following sections.