3 Replies Latest reply: Jun 5, 2018 11:30 AM by Ronald Cadet RSS

    set analysis returns zero

    Ronald Cadet

      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)