Calculate Running Total for "TY"- Current Month and "LY"- Current Month

Hi there,

I am trying to calculate running total for this year and last year. For example, assuming Jan-2020, cases are 20, and Feb-2020 cases are 50, total would be 70. Similarly, Jan-2019, cases 10, and Feb-2019, cases are 30, total would be 40. Having a hard time with this.

See another example.

Did you look at

Hi @etorres,

not sure I understand. My guess would be you need to calculate cumulative sum (using node @izaychik63 linked) for each row if you have data in format that you print screened. If not can you give example of input data and desired output?

Br,
Ivan

Got it working! Rulebase Node + Moving Aggregate did it for me.

Thanks!

2 Likes

Hi @etorres,

glad to hear you made it :slight_smile:

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.