Filemaker Pro 9 (110)

Question 1

This set entered on 7-29-14
7.27.14.2 p. 417

1. In an invoice, the Extended Price calc is inserted in the Line Item. How do you calculate a TOTAL for the invoice?

Answer 1

You have to insert a calculation in the INVOICE.

Question 2

2. How do you do the calculation in the INVOICE layout?

Answer 2

a. Create a field named TOTAL DUE b. Make it a CALCULATION field
c. The SPECIFY CALCULATION Dialog Box pops up and in the “Evaluate this calculation from the context of,” choose INVOICES
d. Choose the AGGREGATE FUNCTIONS
e. Choose the “Sum ( field {; field…} )”

Question 3

3. What’s next, once you’ve chosen the function “Sum ( field {; field…} )”

Answer 3

the next thing you type or click BECOMES THE FIRST PARAMETER TO THE FUNCTION.

Question 4

4. What do the CURLY BRACES mean in the Function above?

Answer 4

Anything in CURLY BRACES in a Function IS OPTIONAL. In this case, everything inside the parenthesis gets replaced.

Question 5

6. What is the next step?

Answer 5

From the “CALCULATION RESULT IS” pop up menu, choose NUMBER, and click OK.