Set Analysis with a Sum IF statement

PamelaAlcantara — Fri, 22 May 2020 17:03:47 GMT

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'

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

Re: Set Analysis with a Sum IF statement

sunny_talwar — Fri, 22 May 2020 17:08:28 GMT

May be this

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