Hi All,
I have below sample table, where count column display the count of Project if it is marked yes in MIL_1 or MIL_2 or both. I am using below Set expression for Count column.
(Count(distinct{<MIL_1={'Yes'}>}ProjectID) + Count(distinct{<MIL_2={'Yes'}>}ProjectID))
| ProjectID | MIL_1 | MIL_2 | Count | |
| 21 | Yes | | 1 | |
| 32 | Yes | | 1 | |
| 45 | Yes | Yes | 2 | 1 |
| 32 | | Yes | 1 | |
| 56 | | Yes | 1 | |
| 67 | Yes | | 1 | |
| 89 | Yes | Yes | 2 | 1 |
Above formula works well, if I have 'Yes' in any one of the column but not if 'Yes' present in both the columns.
Could you please tell help me on this.
Thanks in advance!
Gayatri
