Set Analysis Query - calculate avg value based on max date

[#1]

Hi

I've been trying to work out average turnover for a group of companies based on a the most recent date available, but there's an error in my set analysis somewhere and I'm hoping someone can point it out!  Any and all help would be greatly appreciated

=Avg(

{<Date={$(=Max(Date))}>}

Turnover)

Many thanks

[giakoum · Accepted solution]

try putting the expression in a varable :

=Avg(

{<Date={"$(Variable1)"}>}

Turnover)

or add double quotes:

=Avg(

{<Date={"$(=Max(Date))"}>}

Turnover)

[#3]

Thanks Ioannis - double quotes worked perfectly