Running PREV() or RPREV() still out there?

[wallingfordce]

There was a forum post a long while back about avoiding having to create formulas that add up PREV(1) + PREV(2) + ... + PREV(N) periods to get a rolling average or sum. I can't find it now but it referenced an undocumented function for rolling previous periods - something like RPREV(), but that's not working for me.

Ring any bells?

[DRay]

Hi @wallingfordce,

I'm not able to find specific post, but we do support using R in formulas. Here is the documentation on that. https://docs.sisense.com/main/SisenseLinux/using-r-in-formulas.htm

This post may also help. https://community.sisense.com/t5/build-analytics/prev-query-getting-error/m-p/3369

[wallingfordce]

The "may also help" I already reviewed and outlines the "PREV() series" solution I'm hoping to avoid. And I'm definitely not talking about using R. It's just that the memory I have of the "Running Previous Periods" function was something like RPREV instead of PREV, like RSUM instead of SUM.

Thanks for trying to help though - I appreciate it!

[wallingfordce · Accepted solution]

It was this...

Add a new version of Rolling Sum and Rolling Avera... - Sisense Community

Rolling Trailing 12 Months | Sisense