5 Replies Latest reply: Nov 8, 2012 8:14 AM by Gysbert Wassenaar RSS

    How can I do comparison of two fields with my set analysis?

      I get the notification   "Error in set modifier expression"    for the expression below.  I am trying to get a count for Work Orders where the Closed date is on or before the required completeion date.



      count({$<[WO Close Date.CalendarMonthNum] <= [WO Required Date.CalendarMonthNum], [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID]