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

    Yes / No scores conditioned on Yes scores

    Jesper Miles



      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.