2 Replies Latest reply on Aug 2, 2018 11:05 PM by Jon Boschee

    Window Sum Calculation Issue

    Jon Boschee

      Hi everyone,

       

      I running into something weird in my window sum calculation for my 6 month rolling average.   Below is my volume and sales.  July was the only month with sales in it for the past 6 months.

       

      My window sum is returning 140,880 and 547,037 for volume and sales.  When I go into the full data, I see the numbers below.  Has anyone had this happen?

       

       

       

      YearMonthVolumeSales
      20187-555-3656
      20187-720-4727
      20187-750-4925

       

       

      Thanks in advance