108
Chapter 7
Figure 7-3
Conditional Derive comparing valuesof one field to those of the field before it
CLEM ExamplesToillustrate c orrect syntax as well as the types of expressions possible with CLEM, example
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:
(After- Before) / Before * 100.0
Notice that field names are unquoted when referring to the values of the field.
Similarly,the follow ing expression simply returns the log of each value for the field salary.
log(salary)