Filter
Top Products
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 correct syntax as well as the types of expressions possible with CLEM, example
expressions follow.
Simple Expressions
Formulas ca n 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 w hen referring to the values of the field.
Similarl y, the following expression simply returns the log of each value for the field salary.
log(salary)