Database Reference
In-Depth Information
Figure 4-1. Summing two fields with a Calculated Field
Next, let's create a second calculated field that creates the ratio of recyclable material to re-
fuse. Right-click in the Dimensions or Measures area again and fill out the dialog box as
shown in
Figure 4-2
.
Notice that we put the numerator and denominator in brackets, preceded by
SUM
. This is crit-
ical, because as we move up a level of from community district to borough, we don't want to
add
the individual ratios of each community district; we want to create a new ratio that rep-
resents the quotient of the aggregate amounts. The first approach would create a larger ratio
that is misleading.
