Set Analysis with a Sum IF statement

[PamelaAlcantara]

Hi All, 

I have a requirement to realize a Sum for some items that got a result "Passed"

So I created the following expression:

sum(IF(RESULT='Passed',1,0))

But I do also have to set an analysis based in Variable1  and Variable2.

So, I need to add the following expressions:

Variable1 ='Yes'

Variable2 contains 'Success'

Item	Result	Variable1	Variable2
1	Passed	Yes	Success type 1
2	Failed	Yes	Observation
3	Failed	Yes	Observation
4	Passed	Yes	Success type 2
5	Passed	Yes	Observation
6	Passed	Yes	Success type 1
7	Passed	No	Observation
8	Passed	No	Success type 1
9	Passed	Yes	Observation
10	Failed	No	Observation
11	Failed	No	Observation
12	Passed	Yes	Success type 2

How can I add the set analysis to the original expression?

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<RESULT = {'Passed'}, Variable1 = {'Yes'}, Variable2 = {"*Success*"}>} Item)