Count Max Date with Another Set Analysis Field

[brettaustin]

I am trying to count the total teams with a 'Y' usage for the current reporting period.

WHERE the Usage Flag is 'Y'

AND

The Report Date is the maximum for the current 'reporting period'.  See below for data example

= count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date]))"}>}  RecordID)

Total Should equal 1 because the max date is 4/1/2018

RecordID	Team	Usage	Report Date
1	A	Y	1/1/2018
2	B	N	1/1/2018
3	C	Y	1/1/2018
4	A	N	2/1/2018
5	B	Y	2/1/2018
6	C	N	2/1/2018
7	A	Y	3/1/2018
8	B	Y	3/1/2018
9	C	Y	3/1/2018
10	A	N	4/1/2018
11	B	N	4/1/2018
12	C	Y	4/1/2018

[sunny_talwar · Accepted solution]

May be you are missing a closing parenthesis

=Count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date])))"}>}  RecordID)

[brettaustin]

Argh... Thank you!!!!!

[sasiparupudi1]

if you got your answer, please close this thread by marking a correct and any helpful answers