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

Question

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 · Accepted Answer

It was this...Add a new version of Rolling Sum and Rolling Avera... - Sisense CommunityRolling Trailing 12 Months | Sisense

DRay · Answer

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