Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Now it's clearier, thanks. Quite bothersome IMHO. May I use variables on the left side of the set modifier?
If they evaluate to a field name... then yes... but if not... then you can't
Ok, understood, many thanks.