Calculating Total

[Ertjie]

Im trying to calculate the total amount for a field for the current found set but i wont work! What i have at the moment is a calculation field in my parent table that calculates an amount per record. I want the total of this amount for all records in the found set. I've tried doing this in the child and parent table of the relationship as well as summary fields. Summary fields works, but for ALL records and not just the found set...

Could any body please give any advice?

[comment]

Summary fields summarize the found set (or the related set, if you are looking at a summary field from a related table). I didn't get your explanation of the problem - it's not clear which table you are referring to.