Pbeyrouty Posted January 27, 2009 Share Posted January 27, 2009 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? Link to comment Share on other sites More sharing options...
comment Posted January 27, 2009 Share Posted January 27, 2009 See: http://fmforums.com/forum/showtopic.php?tid/200480/post/314073/#314073 Link to comment Share on other sites More sharing options...
Pbeyrouty Posted January 27, 2009 Author Share Posted January 27, 2009 Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5567 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now