topic How to make a filter between YearStart and Date in App Development

How to make a filter between YearStart and Date

BrunoZaghetti — Wed, 18 Dec 2019 13:17:15 GMT

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...

Re: How to make a filter between YearStart and Date

BrunoZaghetti — Wed, 18 Dec 2019 13:20:03 GMT

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

Re: How to make a filter between YearStart and Date

Anil_Babu_Samineni — Wed, 18 Dec 2019 13:20:11 GMT

Perhaps this?

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

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

Re: How to make a filter between YearStart and Date

BrunoZaghetti — Wed, 18 Dec 2019 13:23:54 GMT

Thanks , the 1st one solved the problem!