3 Replies Latest reply on Feb 15, 2017 1:09 PM by Srinidhi Narayan

    Can't understand WINDOW_SUM

    Esther Twain

      Hello again,

       

      In the step How (3) from the attached workbook, can someone explain to me what is this calculation doing?:

       

      IF WINDOW_SUM([Warnings],-[Moving Window to Consider]+1,0)>=[Incidence Threshold] THEN WINDOW_SUM([Warnings],-[Moving Window to Consider]+1,0) END

       

      Why are they subtracting "Moving Window to Consider" and then adding +1?

       

      Thanks!

      Esther