3 Replies Latest reply on Sep 13, 2016 8:31 AM by Victor Castaneda

    Rolling Table Calculations: Only for Complete Month

    Victor Castaneda



      Is it possible to construct a table calculation that only displays the current month once it's complete? I'm using the following calculation:


      WINDOW_SUM(SUM([Tranche Value $ (Face)]), -2, 0)


      which includes the two previous months and the current value. I tried adjusting the formula to include the previous three months and not the current month but then I get a series that is lagged. Is anyone aware of a workaround?


      Thank you,