2 Replies Latest reply on Sep 5, 2018 11:40 PM by Premnath v

    Window Sum with Offsets

    Premnath v

      Hi Friends,


      I am trying to understand window calculations. Here, what I want is to calculate the sum of sales for particular partition i.e. from Index 1 to index 5. Please refer screenshot.


      I am unable to understand the formula for Window_Sum(Expression, [Start, end])

      Start and end is offset i.e. First()+n and LAST()-n.. while first is always a (-ve) number and Last is (+ve).


      Can you please give and an example of window sum calculations for calculating sum of sales for specific partition.