IBM 15 Manuel D’Utilisation
108
Chapter 7
Figure 7-3
Conditional Derive comparing values of one field to those of the field before it
Conditional Derive comparing values of one field to those of the field before it
CLEM Examples
To illustrate correct syntax as well as the types of expressions possible with CLEM, example
expressions follow.
expressions follow.
Simple Expressions
Formulas can be as simple as this one, which derives a new field based on the values of the
fields After and Before:
fields After and Before:
(After - Before) / Before * 100.0
Notice that field names are unquoted when referring to the values of the field.
Similarly, the following expression simply returns the log of each value for the field salary.
log(salary)