Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
Count(DISTINCT {<RESULT = {'Passed'}, Variable1 = {'Yes'}, Variable2 = {"*Success*"}>} Item)
May be this
Count(DISTINCT {<RESULT = {'Passed'}, Variable1 = {'Yes'}, Variable2 = {"*Success*"}>} Item)