Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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?
Yes, I have verified. it's like you say.
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])
yes, I have created the calendar in that way!
thanks for your answer!!!!!