Lots of ways to do this just depends on how you need to display and what else is going oon in the report (and your preferences).
1. You can use a Running Total to conditionally count the "NO" fields, do a count of all records and then use a formula to show % as
#RT % COUNT(table.field)
2. create a formula to flag make a "NO" 1 and a "Yes" 0 then SUM that formula and do a COUNT of all and divide same as option1.
if table.field = "No" then 1 else 0
3. Use variables to get your counts - same premise as option 1 but use formulas to set your variable up to only count "NO" fields.
4. Group on the YES/NO field, do a COUNT of the records at grouplevel1 and set that as a percentage of the total.
almost forget, do not do anything with the YES/NO field in your select expert.
You can use the date parameters with no issues but if you use the YES/NO field it will exclude the records preventing any precentage from being able to be determined.
Edited by DBlank - 25 Jun 2009 at 8:37pm
IP Logged
