How to make a filter between YearStart and Date

[BrunoZaghetti]

Hello, I'm trying to do a filter in SetAnalysis but it's not working. I need to Sum the field [SPF.QTD_TRANS] only if the field [SPF.DATAREF] is greater than 01/01/2019. My code is:

SUM({$<[SPF.DATAREF]={">=$(YEARSTART(MAX(ALL [SPF.DATAREF])))"}>} [SPF.QTD_TRANS])

What am I doing wrong? I'm trying for a long time...

[BrunoZaghetti]

I tried also

SUM(
IF(MAKEDATE([SPF.DATAREF],'DD/MM/YYYY')>=MAKEDATE(YEARSTART(MAX(ALL [SPF.DATAREF])),'DD/MM/YYYY'),1,0
)

but still not working

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

SUM({$<[SPF.DATAREF]={">=$(=YearStart(Today()))"}>} [SPF.QTD_TRANS])

Or

SUM({$<[SPF.DATAREF]={">=01/01/2019"}>} [SPF.QTD_TRANS])

[BrunoZaghetti]

Thanks , the 1st one solved the problem!