Problem with the calculation.
I don't know how to calculate some values. (I use FMP 11)
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. OLD orders. (xSummaryStatusOLD)
2. NEW orders. (xSummaryStatusNEW)
3. Number of items of each shape ordered (orders with NEW status) (TotalAmountNEW)
4. Number of items of each shape ordered (orders with OLD status) (TotalAmountOLD)
Could you help me?