0 Replies Latest reply: Feb 19, 2018 11:17 AM by David Ehlin RSS

    Running total Rolling12 with ingoing balance

    David Ehlin

      Hi,

       

      anyone who knows how to make this SET-analysis with the QVC-variables?

       

      I think this does what I want but there must be a better way:

       

      "

      rangesum(after(sum($(vSetRolling12) MyValue),0,12))

      //+ IB

      +

      sum({<Year=, [Year-Month]=, Month=, Date = {"<$(=min($(vSetRolling12) Date))"}>}total MyValue)

      "

       

      Regards

      David