Running PREV() or RPREV() still out there?
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?
Chris Wallingford
Posted 1 year ago · Edited 1 year ago·Last reply 1 year ago
3 comments
Chris Wallingford
OP1 year agoIt was this...
Add a new version of Rolling Sum and Rolling Avera... - Sisense Community
Rolling Trailing 12 Months | Sisense
DRay
·1 year agoHi 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
Chris Wallingford
OP1 year agoThe "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!