Problem with calculation of the quantity.

[Creek]

I have a problem how to calculate some values.

I have 2 tables (Orders and Shapes). Orders is in a relationship with Shapes.

Copy database in the attachment.

Eeach order covers items of one shape, specify the amount of items ordered and receives status (NEW or OLD).

I'd like to know:

1. Orders in total. (xSummaryStatus)

2. OLD orders. (xSummaryStatusOLD)

3. NEW orders. (xSummaryStatusNEW)

---

4. How many items of each shape has been ordered? (TotalAmount)

5. Number of items of each shape ordered (orders with NEW status) (TotalAmountNEW)

6. Number of items of each shape ordered (orders with OLD status) (TotalAmountOLD)

Sums.zip

PS. I use FMP 11

EDIT:

I found the answer to question 1 and 4. New files in attachment

Sums2.zip

[Creek]

I found a solution

If someone wants to know.

For questions 2 and 3 - I used the function "COUNTIF".

http://fmforums.com/...__fromsearch__1

For questions 5 and 6 - I used the function "TypeSumFiled".

http://www.briandunning.com/cf/894

I don't have the FM Advanced. I had to modify the code and put in "Specify Calculation"