3 Replies Latest reply: Aug 11, 2017 8:06 AM by Sunny Talwar RSS

    Count AT LEAST 1or more responses

    Saima SM

      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