Efficient calculations
Calculations may be constructed differently and yet accomplish the same thing. Look, for instance, at the following example, which shows that an IF
statement can be replaced by simpler code:
Scenario I |
Scenario II |
Create a calculated field with the following code:
Place the calculated field on the Colour shelf. |
Create a calculated field with the following code:
Place the calculated field on the Colour shelf. Right-click on True and False in the resulting legend and rename to Profitable and Unprofitable. |
Since either of these scenarios...