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

Format the field for %. Under Format, go to Number, click Format as decimal. check Use notation:, and select Percent from the popup menu. You can also check Fixed number of decimal digits.