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