Why this expression is working while this other won't

[Anonymous]

Hello everyone.

I'm trying to understand why this formula

"COUNT({<[subscribe_date.autoCalendar.Year] = {$(vMaxSubscribeYear)}>}subscribe_date)"

is working while

"COUNT({<YEAR([subscribe_date.autoCalendar.Date]) = {$(vMaxSubscribeYear)}>}subscribe_date)" isn't.

YEAR([subscribe_date.autoCalendar.Date] shouldn't be equal to [subscribe_date.autoCalendar.Year]?

What am I misunderstanding?

[sunny_talwar · Accepted solution]

You are not allowed to use functions such as Year(), Sum(), Min() on the left hand side of the set modifier... you can only use field names

[Anonymous]

Now it's clearier, thanks. Quite bothersome IMHO. May I use variables on the left side of the set modifier?

[sunny_talwar]

If they evaluate to a field name... then yes... but if not... then you can't

[Anonymous]

Ok, understood, many thanks.