AnsweredAssumed Answered

Problem with the calculation.

Question asked by creek on Nov 21, 2011
Latest reply on Nov 24, 2011 by creek

Title

Problem with the calculation.

Post

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)

http://www.4shared.com/file/ug3OOr9l/Sums.html

Could you help me?

Outcomes