topic Re: QS - Set Analysis in App Development

QS - Set Analysis

peterkumar — Wed, 08 May 2019 21:05:33 GMT

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 — Wed, 08 May 2019 22:02:38 GMT

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 — Thu, 09 May 2019 10:50:32 GMT

You can also try this

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

peterkumar — Thu, 09 May 2019 13:46:00 GMT

Many thanks Sunny!

That worked fine.