Skip to main content
A
Anonymous
November 18, 2019

how to calculate an average of Prior 8 or 12 quarters on a rolling basis? has anyone done it? please share.

  • November 18, 2019
  • 1 reply
  • 0 views
Originally posted by Ashok Amresh

I am trying get rolling average of an Account (i.e. average of prior 8 OR 12 quarters  ). i am New to Onestream and really finding hard to find function etc. any help is appreciated.

1 reply

T
TonyToniTone
September 14, 2021

I would suggest to try using a combination of the Time Dimension and the View Dimension to potentially resolve this.  Try using T#QuarterPrior8():V#QuarterAvg

Terms & ConditionsAccessibility statement