I'm trying to chart a distinct count of records based on the change of a formula. My problem is that for one result of the formula all of the records meet the criteria.

For every group record there is a set of tasks in the details. Every group record has 'Task A'. Only a subset has 'Task B'. My formula labels the tasks, but when i try to summarize in a chart with a distinct count of the parent records, it sees the 'Task B' items but then also shows all of the 'Task A' items, thus skewing the total 'Task A' count by the amount of records with 'Task B'.

e.g. 100% of records meet criteria A only 42% meet criteria B therefore 58% do not meet criteria B.

How do I get my chart to differentiate that parent records with 'Task B' should NOT be included in the count of parent records with only 'Task A'?

Edited by ssturde - 10 Feb 2012 at 9:56am