Annual rolling Avgerage

[#1]

I know the rolling n periods topic is constantly brought up, i have read through several posts and documents. I am struggling to find a solution that will give me and Annual Average based on a rolling 36 months.

[#2]

try this in expression

DATE={'>=$(=AddMonths(max(DATE),-36))'}

[#3]

This is returning an error in the expression

[#4]

can you provide sample document or ur to understand well where you r applying it

[SreeniJD]

Hi Zeth

Try this,

avg({<Date={‘>=$(=MonthStart(Max(Date), -35))<=$(=Date(Max(Date)))’}>} field_name)

HTH,

Sreeni