I have a report that is supposed to list all the records that have both a "WCP" and a "PPU" code. I added the following Group Selection Formula: Count ({incident_rprt_problem_subcode.problem_subcodes}, {incident_report.incident})=2
Among other conditions the Select Expert shows this: {incident_rprt_problem_subcode.problem_subcodes} in ["PPU", "WCP"]
I have a group for each {incident_report.incident} which includes the fields of the report. I suppress the detail section. The report correctly list the necessary data but shows the report total wrong. The report total includes records with either a "WCP" or a "PPU" code, not just those with both. What do I need to do to get the report totals to be correct?
