Database Reference
In-Depth Information
The function list now shows just the functions FileMaker uses to calculate various
kinds of totals and averages. You're looking for the sum function.
5.
Double-click the
Sum ( field {; field…} )
function in the list
.
FileMaker copies the full function example into the calculation box. To save you an
extra step, it even selects everything between the parentheses (
Figure 9-6
). The next
thing you type or click becomes the first parameter to the function.
TIP
Anything within {curly braces} in a function is optional. In the
Sum()
function in step 5, you
could reference several fields that all get summed up into one glorious total. But that doesn't
make sense when you're trying to summarize line items on an invoice, so you're just repla-
cing all the highlighted material with a single field reference.
6.
From the pop-up menu above the field list, choose Line Items to view the table
occurrence you need and then, in the list of Line Item fields, double-click the Ex-
tended Price field
.
FileMaker adds this field to the calculation, placing it between the parentheses that
surround the parameters to the sum function. Your calculation should now read:
Sum ( Line Items::Extended Price )
7.
From the “Calculation result is” pop-up menu, choose Number
.
Because this field was a number type before you changed it, it's probably already set
to have a Number result.
