QS - Set Analysis

[peterkumar]

Good Afternoon - 

I will appreciate guidance on the set analysis below.  The first argument works fine, but the second one is being ignored.  

Count({$<[S-Account Mapped]={'Y'}, "=left([S-Date],4)"={'2016'}>}[S-Account Mapped])

Thank You!!

[jwjackso]

I've never done it that way, you might have better luck with:

Count({$<[S-Account Mapped]={'Y'}, [S-Date]={">=$(=MakeDate(2016,1,1))<=$(=MakeDate(2016,12,31))"}>}[S-Account Mapped])

[sunny_talwar · Accepted solution]

You can also try this

Count({<[S-Account Mapped] = {'Y'}, [S-Date] = {"=Left(Only({1} [S-Date]), 4) = 2016"}>} [S-Account Mapped])

[peterkumar]

Many thanks Sunny!

That worked fine.