January 27, 200917 yr 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?
Create an account or sign in to comment