7 Replies Latest reply: Nov 27, 2017 6:00 AM by Jesper Miles RSS

    Yes / No scores conditioned on Yes scores

    Jesper Miles

      Hi,

       

      I have a speedometer, which need to display a score of:

       

      Column A (Yes scores) / Column B (No scores)

       

      But Column B (No scores) needs to only count the answers where they have selected (Yes scores) in Column A and (No scores) in Column B.

       

      At the moment I use

      sum(if(match([Var der udsolgte situationer da du ankom?],'Ja'),1,0))/sum(if(match([Er der fortsat udsolgte situationer når du forlader butikken?],'Nej'),1,0))

       

      This will sum every yes score, and every no score instead of conditioning the no scores based onthe yes scores.

       

      Hope this makes sense.