1 Reply Latest reply on Sep 14, 2016 12:13 PM by Andrew Watson Branched from an earlier discussion.

    Running_SUM on Prior_4_Wk_Avg Calculation (excluding prior days)

    nigora.sharipova

      Jonathan Drummey; Andrew Watson, Zach Leber, Joshua Milligan; Shawn Wallwork, Jim Wahl

       

      Hi Everyone,

       

      I would appreciate your input on this task. I am attaching a sample workbook, where i try to calculate running_sum on prior_4_wk avg calculation. The first tab has two metrics (ordercnt and ordercnt_prior 4 wk avg) by hour for the selected period. The second tab has running_sum on ordercnt, which works correctly. However, the same calculation fails for the prior 4 wk avg metric and shows blank (tab 2). I assume it has to do with the date filter which is impacting the underlying calculation.

       

      Would appreciate any suggestions. Thanks!