User's Manual

108
Chapter 7
Figure 7-3
Conditional Derive comparing values of one field to those of the field before it
CLEM Examples
To illus trate c orrect syntax as well as th e types of exp r essions possible with CLEM, example
expressions follow.
Simple Expressions
Formulas ca n be as s imple as this one, which derives a new field based on the values of t he
fields After and Before:
(After - Before) / Before * 100.0
Notice that field names are unquoted wh en refer r ing to the v alues o f the field.
Similarl y, the following e xp r ession simply return s the log of each value for the field salary.
log(salary)