2 Replies Latest reply on Feb 16, 2016 8:20 AM by EIS SW

    Sum if AND ...

    EIS SW

      Hi everyone,

       

      I am trying to write an equation that tells me what % winners had a mean score of less than 5. (winners with mean score<5)/total winners*100

      So far I have this:

       

      sum((if [Finishing Position (overall)] = 1 AND ([Avg Fleet Score] < 5)) / (sum(if[Finishing Position (overall)] = 1)) *100

       

      I think I need to have a then in there somewhere but not sure, if anyone can help that would be great!

       

      Thank you v much

      Emilie