Filemaker Pro 9 (116)

Question 1

This set entered on 8-3-14
8.2.14.5

1. When calcs start to get complicated like the DISCOUNT PRICE example, you need to:

Answer 1

imagine that you have a field that contains THE VALUE YOU ALREADY WANT. You can use this PRETEND field in your calc, and then, when you are all finished, put the old calc in place of the pretend field.

Question 2

2. In this case, just pretend you have a field called:

Answer 2

CALCULATED DISCOUNT, that holds the DISCOUNT PRICE.

Question 3

3. With that IMAGINARY FIELD, you can fix the problem with this calc:

Answer 3

Min ( Calculated Discount ; Price)

Question 4

4. The result of this calc is:

Answer 4

either the CALCULATED DISCOUNT or the REGULAR PRICE (if it is lower).

Question 5

5. Now, just put the OLD CALC in place of the words:

Answer 5

CALCULATED DISCOUNT (since the old calc results in the CALCULATED DISCOUNT).

Question 6

6. The finished calc is, including comments, is:

Answer 6

/* returns the calculated discounted price or the original price, whichever is lower*/

Min ( Max (Price * .95 ; Cost * 1.2 ) ; Price )