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

    Rolling Table Calculations: Only for Complete Month

    Victor Castaneda

      Hello,

       

      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,

      Victor