Rolling sum for 12 months RPSUM

Question

I want to get a rolling sum for 12 months broken by each month. In past community posts it was mentioned to use a function "RPSUM". could not find this function is this function deprecated now?

https://community.sisense.com/t5/knowledge/rolling-trailing-12-months/ta-p/565

Is there any other way to achieve this

dray · Answer

Hello&nbsp;datanerd,
I am reaching out to internal resources to try and get an answer for you.
&nbsp;

dray · Answer

Hello&nbsp;datanerd,
RPSUM function has been deprecated from function reference page and documentation a long time ago. But here's a fun fact, it still works. You just need to type it inside the Formula Editor and it works.

Forum Discussion

Rolling sum for 12 months RPSUM

2 Replies

Recent Discussions

JavaScript does not work for Tabber

Disappearing widgets

Two calculations displaying separately in a single field

Webhooks on MS Teams

Build To Destination Failure

Sisense

Support

Resources