After testing I'm fairly convinced that the suppression formula is only evaluated based on the first subgroup-level it sees.

In other words, Group 2's suppression would really depend on whether or not the first instance of Group 3 is a postive or negative. If the first instance of Group 3 is a positive, it will not suppress Group 2. So technically, it does what the suppression tells it to do but there is a problem when there's multiple Group 3's with mixed positive and negative numbers.

If Group 3 has 3 items showing in the order of negative, postive, negative, Group 2 will look at the first negative of Group 3 and suppress itself. Unfortunately, then that means on the actual report, it will suppress Group 2 but show just the positive instance of Group 3 without a Group 2 instance.

How can I rewrite this suppression formula so it evaluates all the items under Group 3? Is this even possible?

## Add comment