Jump to content

Summary field problems.


This topic is 6514 days old. Please don't post here. Open a new topic instead.

Recommended Posts

OK, I have a report layout. That has a couple of sub-summary parts. Summarized by Person assigned to. I have a Completed % that I want to display. I have a summary field defined as Average of completed within 10days field. The completed within 10 days field is a calculated field. I also have a total completed. Now the Average completed summary field summarizes correctly.

example. Total completed = 16, completed with 10 days = 5 Average completed = .3125

Now when I create another calculation field with the formula of average completed * 100 to display the above result as 31.1% the value in the new display field comes up with 61.98. For each summarized section. So I believe it is showing me a total for all the records. Not just the ones summarized by person. What's up? I can't out how multiplying a summary field with the value of .3125 by 100 gives me 61.98. What am I missing. TIA.

Paul

Version: v5.x

Platform: Mac OS X Panther

Link to comment
Share on other sites

This topic is 6514 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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