Hi,
If you're looking for an average over the last 12 months you can do like below:
sum({$<Date={">=$(=monthstart(today(),-12))<$(=monthstart(today()))"}>}Field)/12
So this sums the "Field" where the "Date" is greater than the start of the month from today's date, 12 months ago, and the "Date" is less than the beginning of the current month.
You may not need this depending on your requirement.
I have used monthstart() function but if you need the exact date, 12 months ago you can replace it with addmonths(today(),-12)
I hope this helps.
Thanks
Anthony
