Hi Everyone,
I want to calculate the average number of performances in someone's account, and wanted to check that I have the right formula. Screenshot below. Has anyone tried this before? Am I on the right track?
If I also wanted to calculate average number of performances over five years, would I use the min/max calendar function?
Screenshot below. Thanks so much!
Just like to say I really like this formula. I tried it out this morning and then validated it against some patron accounts, and they all matched. This is very useful in looking at constituents over many years or seasons throughout a year.Thanks for this tip!