Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Count Max Date with Another Set Analysis Field

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
1 Solution

Accepted Solutions
MVP

May be you are missing a closing parenthesis

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

3 Replies
MVP

May be you are missing a closing parenthesis

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

Contributor III
Author

Argh... Thank you!!!!!

Master III