Jump to content
Sign in to follow this  
Pbeyrouty

Calculation field not working in sub-summary

Recommended Posts

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?

Share this post


Link to post
Share on other sites

See:

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.