set analysis returns zero

[Anonymous]

I hope someone can help me find out what is wrong with this set expression.  The result is always zero no matter what i try to do to it.

=Count({$<CalendarMonthYear ={"$(= '<=' Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

[Anil_Babu_Samineni · Accepted solution]

This should like

=Count({$<CalendarMonthYear ={"<=$(=Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

OR

=Count({$<CalendarMonthYear ={"$('<=' & =Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

[sunny_talwar]

For your expression you are missing a $... and you also had a misplaced parenthesis

=Count({$<CalendarMonthYear = {"$(='<=' & Date(MonthStart(Max(CalendarMonthYear),-1), 'MMM-YYYY'))"}, Object_A ={"<=30"}>} DISTINCT Jobs)