Running total Rolling12 with ingoing balance

dajjan81 — Mon, 19 Feb 2018 16:17:34 GMT

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

topic Running total Rolling12 with ingoing balance in App Development