Syntaxis to set analysis of a previous year

[#1]

Hi,

I have this expression and I am not able to get the average corresponding to the previous year as the one selected in the document, is only a syntax question because the expression works properly if I do not consider the year in the set analysis expression.

How to write it correctly?

-AVG({<HOTEL_EMPRESA={'KIP'},TIPO_EMPRESA={'HOTEL'},YEAR={=YEAR-1}>}TASA_BUDGET_EUR)

Thanks

[#2 · Accepted solution]

This is a bit of a guess; but, does this help?

AVG({<HOTEL_EMPRESA={'KIP'},TIPO_EMPRESA={'HOTEL'},YEAR={"$(=YEAR-1)"}>}TASA_BUDGET_EUR)

[#3]

Thank you very much

I tried millions of combinations whith all possible symbols