Efficient calculations

Calculations may be constructed differently and yet accomplish the same thing. Look for instance at the following example which shows that a If statement can be replaced but simpler code:

Scenario I		Scenario II
Create a calculated field with the following code: IF SUM (Profit) > 0 THEN'Profitable' ELSE'Unprofitable' END Place the calculated field on the Color shelf.		Create a calculated field with the following code: SUM (Profit) > 0 Place the calculated field on the Color shelf. Right-click on 'True' and 'False' in the resulting legend and rename to 'Profitable' and 'Unprofitable'.

Since either of these scenarios will return the desired results, which should be used? The deciding factor is performance. This section will explore what to do and what to avoid when creating...