cancel
Showing results for 
Search instead for 
Did you mean: 

Rolling sum for 12 months RPSUM

datanerd
8 - Cloud Apps
8 - Cloud Apps

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

2 REPLIES 2

DRay
Community Team Member
Community Team Member

Hello @datanerd,

I am reaching out to internal resources to try and get an answer for you.

 

David Raynor (DRay)

DRay
Community Team Member
Community Team Member

Hello @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.

David Raynor (DRay)
Community Toolbox

Recommended links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]