Year(field) in Set Analysis doesn't work

[#1]

Before asking , I have found a similar topic but it doesn't work when trying to adapt mine.

I want to filter the result by counting only the records of this year

if I display the =YEAR(SCContract__c.StartDate__c) then I get 2013 , 2014 ...

here my expression

I want to consider all the values , so I did use the {1

but how to evaluate the Year of the StartDate ?

=COUNT({1<{$(=YEAR(SCContract__c.StartDate__c))}={'2014'}>}SCCContract__c.StartDate__c)

Thanks for your explainations

Alban

[SergeyMak]

As I know you can't use formula in the left part in set analysis.

Just do YEAR(SCContract__c.StartDate__c) AS YearStartDate in load script

and then use

COUNT({1<YearStartDate={2014}>}SCCContract__c.StartDate__c) as your expression

[its_anandrjs]

Try with

Max(YearFieldValue) in the expression