Count if the date is on the current year

[camila1]

Hi everyone!

I don't know why I have an error in this expression, someone could help me please?

= Count({<year([fecha inicial.wos])= year(today()),([sigue abierta.wos]= {'No'})>} wonum.WOS) / Count(wonum.WOS)

[Or]

You can't use functions this way within set analysis. Try instead:

Count({<year([fecha inicial.wos])= {"=year(today())"},([sigue abierta.wos]= {'No'})>} wonum.WOS) / Count(wonum.WOS)

[vinieme12]

You cannot use Functions on the left side of the  = , you need to use actual fields

create a new field in your table year([fecha inicial.wos]) as year_fechainicialwos

Then in expression use the field

= Count({<year_fechainicialwos= {"=$(=year(today()))"},[sigue abierta.wos]= {'No'}>} wonum.WOS)

/ Count(wonum.WOS)