Skip to main content
0
0405V
Newcomer
June 30, 2023

function that can be used in a member formula

  • June 30, 2023
  • 1 reply
  • 0 views

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. 

0405V_0-1688086356487.png

Thank you.

 

1 reply

O
Omkareshwar
Contributor
June 30, 2023

You can use View dimension for this.

Omkareshwar_0-1688100132988.png

Thanks, Omkareshwar

Archetype Consulting

 

    Terms & ConditionsAccessibility statement