If you place the "FalseCount" on the detail section it should return a 1 whenver that row is false and a 0 when it is not. If that is not working the rest of the process won't either.
The rest of it is using two Summaries to get your percentage. a SUM / COUNT. We can add the if-then to handle the division by 0 error later.
The Employee Group should have been called AnalystGroup. When you Summarize data at a group level you have to indicate which group by using the field you grouped on as the second condition for the summary...aggregate function(field tosummarize, group field)...
I don't know what you grouped your analyst on, an ID#, a name or something else.
So I want to get a SUM of the FalseCount per analyst divided by the COUNT of all records per analyst.
Create a new formula as "Analyst%":
Place this on the Analyst Group footer
IP Logged
