Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to calculate AT LEAST ONE response as Yes in all three V1, V2, V3 fields . I am using following expression. Is there any other short way out to get this? Because I also have to calculate AT LEAST 2 OF 3 etc.
V1={'Yes'}>*<V2={'No'}>*<V3={'No'}>+
<V1={'No'}>*<V2={'Yes'}>*<V3={'No'}>+
<V1={'No'}>*<V2={'No'}>*<V3={'Yes'}>} distinct EmpID)/count(distinct EmpID)
Thanks
you can created flag in the script for each of the condition and then use the flag in your expression instead of whole condition.
May be this
One Response as Yes
=Count(DISTINCT {
<V1 = {'Yes'}, V2 = {'No'}, V3 = {'No'}>+
<V1 = {'No'}, V2 = {'Yes'}, V3 = {'No'}>+
<V1 = {'No'}, V2 = {'No'}, V3 = {'Yes'}>} EmpID)
Atleast 2 of 3
=Count(DISTINCT {
<V1 = {'Yes'}, V2 = {'Yes'}, V3 = {'No'}>+
<V1 = {'No'}, V2 = {'Yes'}, V3 = {'Yes'}>+
<V1 = {'Yes'}, V2 = {'No'}, V3 = {'Yes'}>+
<V1 = {'Yes'}, V2 = {'Yes'}, V3 = {'Yes'}>} EmpID)