
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count Groups if condition is met
I have the following data (Example):
Object | Status |
A | 1 |
A | 2 |
A | 3 |
B | 1 |
B | 2 |
C | 1 |
C | 2 |
C | 3 |
D | 1 |
I would like to calculate how many Object (types) do not have status "2". In the given example this would be 1 since only object (type) D does not have the status "2".
I would like to do this using an expression.
Thanks for the help!
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There's probably a good way to do this in one formula, but as a quick hack:
Count(distinct Object) - Count(distinct {<Status = {2} >} Object)
[Edit]
And I believe the cleaner way here would be:
Count( distinct {$<Object= E({1<Status={"2"}>})>} Object)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There's probably a good way to do this in one formula, but as a quick hack:
Count(distinct Object) - Count(distinct {<Status = {2} >} Object)
[Edit]
And I believe the cleaner way here would be:
Count( distinct {$<Object= E({1<Status={"2"}>})>} Object)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Added a cleaner version in an edit to the original post, if you prefer.
