5 Replies Latest reply on Oct 8, 2018 6:07 PM by Joe Oppelt

    Windows Function if, then, else statement

    Arron Robles

      Hello i am writing an incentive. I am having issues writing this statement can anyone assist.

      So if the teams that are playing have the max value or the highest number wins. Then i want to award them 7 points else 0.

      Offense.PNG

      So something like this::

      IF WINDOW_MAX(sum([DEFENSE]))
      THEN 7
      ELSE 0 
      END
      

       

      Not sure how to write this statement.

       

      Cheers~

      Arron