Date with set analysis

[s_santalucia]

Hello,

I have a question for you:

why does this formula not work?

count({$<[Data.autoCalendar.Year]={">2016"}>} [Num])

I want count [num] when data is > 2016.

Thanks

[jwjackso]

The formula worked for me.  Did you verify that [Data.autoCalendar.Year] is a 4 digit year and that you have data greater than 2016?

[s_santalucia]

Yes, I have verified. it's like you say.

[sunny_talwar · Accepted solution]

Not sure how you are defining your autoCalendar, but a lot of the time Year field is a Dual field created like this

If this is how you create it... then try this and see if this works for you

Count({$<[Data.autoCalendar.Year] = {">$(=YearStart(MakeDate(2016)))"}>} [Num])

[s_santalucia]

yes, I have created the calendar in that way!

thanks for your answer!!!!!