Summary field in calculation

[lgaray]

I have a file called Season_Setup_Line_Items that adds up ticket totals for a season using a summary field. Then I have another file that generates a report for all ticket totals (including season tickets) called Ticket Inventory. I want to use the total from the summary field in a calculation in the Ticket Inventory file, but when I try this it only works for one record (event). When I run the report for a different event, I get incorrect results. I don't know how to get the total for a set of records in a file, and use that total in calculation in a related file.

Please help!!

[Kurt Knippel]

All of the summary functions work across a relationship. So assuming that you had a relationship that included all of the records that you wanted to total: cSum = Sum(Relationship:TotalField) will give you to sum of all the TotalField in all the records in the relationship.