Print Page | Close Window

Report Percentage Question Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14825 Printed Date: 05 May 2024 at 4:12pm Topic: Report Percentage Question Posted By: RcJ2 Subject: Report Percentage Question Date Posted: 31 Oct 2011 at 8:36am New asking questions but I've been using the forum for a while. Finally ran into an issue I can't seem to find help for so any assistance is greatly appreciated. I have a report that shows several numbers. They are as followed: Overall Total of Employees (count) Total of members (formula) Percentage of members (formula) Overall total of paying (formula) Percentage of paying (formula) Everything seem to be working correctly except my last group of numbers. My formula is set as : RoundUp((Sum ({@is_paying}, {tblshops.Name})/Count ({tblEmployee.id}, {tblshops.Name})*100)) This is giving me a percentage based on my overall total when I only want it to give me a percentage based on total of members. Please help!! Replies: Posted By: kostya1122 Date Posted: 01 Nov 2011 at 8:34am  try using distinctcount

Print Page | Close Window