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