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
  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    2 years ago

    You can use View dimension for this.

    Thanks, Omkareshwar

    Archetype Consulting