How To Use Logical Expressions In Other Calculated Expressions?
Logical expressions return a True or False value. If you use a logical expression as part of a calculation, then,
- A True is replaced with 1.
- A False is replaced with 0 as the whole expression is evaluated.
This allows you to easily write and compute formulas that involve logical conditions.
Consider the following expression:
([Cost] < 100) * 1 + ([Cost] >= 100) * ([Cost] < 200) * 3 + ([Cost] >= 200) * ([Cost] < 300) * 5 + ([Cost > 300) * 7
Depending upon the value of cost, this expression returns 1, 3, 5 or 7. This is an example of using a linear combination of logical expressions that times other values.
The logical conditions are mutually exclusive, but, when taken as a whole, cover all possible values of cost. It has the effect of assigning a unique value depending upon the input value.