15. VIFRED Field Specifications : Derived Fields : Guidelines for Specifying Derivation Formulas
Share this page                  
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.