The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

0405V's avatar
0405V
New Contributor II
2 years ago

function that can be used in a member formula

Do we have a function that can be used in a member formula that will calculate the average of the last 3 periods.

Example: If my current forecast month is June, I want to calculate the average for the months of May, April, March for which I have actuals for a given account. 

Thank you.

 

planning
Time

1 Reply

  • Omkareshwar's avatar
    Omkareshwar
    Contributor
    2 years ago

    You can use View dimension for this.

    Thanks, Omkareshwar

    Archetype Consulting