2 of 2 people found this helpful
I'm working in 9.1, so I can't attach a workbook, but here's what I've done, maybe it will help. Create another formula, I called mine Pass|Fail. The formula is this:
If [Check 1]="Fail"
THEN [Number of Records]
Replace your sum(Number of Records) with this, and adjust your filter to show both Pass/Fail. The result will only be the count of the records that Fail, and anything that passed won't display a number. You could also change it to count instead of Sum, in which case the records that have no failures would display a 0 instead of a blank.
Is that what you're trying to get to?
Thanks Ann, this is a pretty cool approach to solving the problem. I have used a similar method for other work-arounds in the past and hadn't thought of it. Your answer is not wrong, but Rody's problem also solves the problem using a built-in feature.
Thanks Rody, I can't believe all my Google/forum searches didn't reveal that functionality!
Yeah this is one of those features you find out about at 3:30 in the morning when you can't sleep. You'd be surprised how many features like this go undocumented or aren't discussed frequently. Here an example of a few more
I'm glad it resolved you issue!