Im trying to add a count of loans open for current month year in the title

[#1]

I have a need to create the count of loans open in the current month/year with additional specific criteria. I'm having quite a bit of trouble with this. It is not enough to just see open loans, I need to narrow this down to always show the max open month/year.

I have a calendar items created in the script:

Load
                TempDate AS [LOANOPENDATE],
                week(TempDate) As [LOANOPENWEEK],
                Year(TempDate) As [LOANOPENYEAR],
                Month(TempDate) As [LOANOPENMONTH],
                Day(TempDate) As [LOANOPENDAY],
               date(monthstart(TempDate), 'MMM-YYYY') as [LOANOPENMONTHYEAR],
                ApplyMap('QuartersMap', month(TempDate), Null()) as [LOANOPENQUARTER],
                Week(TempDate) & '-' & Year(TempDate) as [LOANOPENWEEKYEAR],
                WeekDay(TempDate) as [LOANOPENWEEKDAY]
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;

I have created a variable

varMaxLoanOpenMY as  =var(max(LOANOPENMONTHYEAR)

I'm trying baby steps to get each piece to work, but I get an error with this syntax:

count({<LOANOPENDATE={$(varMaxLoanOpenMY)}>}LOANID)

I'd like to add additional criteria such as:

not isnull(LOANOPENDATE) and isnull(CHARGEOFFDATE) to eliminate non-booked loans and charged off loans.

Any help would be appreciated!