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)