Calculation field not working in sub-summary

[Pbeyrouty]

This has me very confused. I am trying to put together a report. In a subsummary there is a calculation field. The calculation is based on two summary fields. Basically s_TotalEarned - s_TotalUsed. In the sub-summary where I seperate by people I also display these two fields and they look fine. But the calculation field shows data that is s_TotalEarned - s_TotalUsed(but for everyone in the query). These records keep track of how much is used. The amount earned is calculated elsewhere, so I cannot do the subtraction in each records then summarize that field. Does anyone know a way around this?

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/200480/post/314073/#314073

[Pbeyrouty]

Thanks!