How to calculate last year's average to use in this year's projections
I'm trying to calculate the average fee per event earned for the previous year and add that as a constant to a dataset to use to calculate projected fees for the upcoming quarter. I can calculate the constant by using Group By to get the average fee by year and then adding a filter formula to isolate the prior year but how…
