Max Month Count

[danieldors]

Hello,

Im looking to change the formula below to capture the last month of data or max month, instead of the current month.

=((Count({<[InterviewCompletedDate.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}
,[Int by Assigned ESS]={"1"}>}
Region)

Thank you.

[JuanGerardo]

Hi,

Replace Today () with $(=Max([InterviewCompletedDate.autoCalendar.Date]))

JG