Help with minimum month and next month in set analysis

[helen_pip]

Hello

I have written an expression where I am trying to find the count of the minimum month in my dataset.   I also aim to create another expression which shows a count of the next month in the data set.   The following part of the expression works on it's own in buttons etc, but I cannot get it to work in an expression and with a count

(Works perfectly)

=

monthstart(AddMonths(min({1}Inpatients_PatientLevel_Diag_Weekly.In_breach_month_6_week_formatted),+1))

(The part highighted in red seems to be creating the problem)

=

COUNT({< { $(monthstart(AddMonths(min({1}Inpatients_PatientLevel_Diag_Weekly.In_breach_month_6_week_formatted),0))}>)

Inpatients_PatientLevel_Diag_Weekly.In_ur_number)

Can anyone help?

Thanks

Helen

[Nicole-Smith]

It needs to look like this:

=count({<Inpatients_PatientLevel_Diag_Weekly.In_breach_month_6_week_formatted={'$(monthstart(AddMonths(min({1}Inpatients_PatientLevel_Diag_Weekly.In_breach_month_6_week_formatted),0)))'}>}Inpatients_PatientLevel_Diag_Weekly.In_breach_month_6_week_formatted)

In set analysis you must have something = something else.