This content has been marked as final. Show 7 replies
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.