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)


      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!