I have a found set list of sales in a report sorted by payment type. I have a summary field totaling the amount pertaining to the specific payment type. Now i need to do some calculations on those summary fields. Is this possible? eg:

----------------------------------

Credit - 175.51 <----Summary Field that requires calculation

Item 1 - 35.12

Item 2 - 123.72

Item 3 - 13.67

Check - 100.00 <----Summary Field that requires calculation

Item 4 - 100.00

Cash - 193.62 <----Summary Fiels that does NOT require calculation

Item 5 - 28.62

Item 6 - 15.00

Item 7 - 150.00

----------------------------------

Any and all information would be appreciated. I'm new to FMP7 as I have been only using it for 2 months. Thank You

Marvin J

Can anyone help me. If this question has been asked numerous times before, I apologize and ask that someone point me toward a post that might help....plz?? Thank you.

Depending on what you're trying to accomplish, using a self-relationship based on the Category (or whichever field contains 'Credit', 'Check', or 'Cash') and then using Sum(selfrelationship::Amount) in your calculation may be easiest. If you only want to include the found set and not all categorically-related records, then you can look at this thread for a similar solution.