Problem with calculation of the quantity.

November 20, 201114 yr

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)

PS. I use FMP 11

EDIT:

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

November 24, 201114 yr

I found a solution

If someone wants to know.

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

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

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

Create an account or sign in to comment