06-29-2023 08:55 PM
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.
06-30-2023 12:42 AM
You can use View dimension for this.
Thanks, Omkareshwar
Archetype Consulting