2 Replies Latest reply on May 13, 2017 5:00 PM by Christoph Wolf

    Combined Table Rank - how?

    Christoph Wolf




      I'd like to rank according to three criteria to get a properly ranked soccer table (just like here):


      1. points (Punkte) - descending


      if points are equal look at


      2. +/- - descending


      if points and +/- are equal look at


      3. goals (Tore) - descending


      I tried this formula (STR(RANK(SUM([Punkte_gesamt])))+ "-" +STR(RANK(SUM([Tordifferenz]))))+ "-" +STR(RANK(SUM([Tore_gesamt]))) but i did't work since "Tordifferenz" and "Tore_gesamt" were rank the wrong way (ascending)


      Any ideas and help appreciated!