OR Condition in Set expression

[gayatri7]

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

[tresesco]

Try:

=Count(DISTINCT {<MIL_1={'Yes'}> + <MIL_2={'Yes'}>} ProjectID)

[gayatri7]

Cool Thanks!

I just realized the same after posting question. Thanks for you reply!