Calculating a year previous using set analysis and alternate states

[mattphillip]

Good morning,

I'm hoping that someone might be able to help me. I'm trying to build an expression to calculate an aggregation based on a year previous. So far I've got this but it doesn't work. The alternate states part is included due to another object we're planning (however it may be dropped!).

=NUM(sum({$<[ReportDate]= [State 1]::[ReportDate]-365,[Fees]={'EU','Home','RUK (Nursing)'},[Level]={'UG','PG Taught'},[SFC Funded]={'Yes'}>}FTE),'0.0')

ReportDate is our date field. In a text box I trialled the following code which worked:

=date(ReportDate-365)

I can't think of a way of adding this to the above set analysis in a was that will work. Does anyone have any ideas?

Many thanks!

Matt