Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
)
Try something like this:
count({$<[WO Close Date.CalendarMonthNum] = {"=[WO Close Date.CalendarMonthNum]<=[WO Required Date.CalendarMonthNum]"}, [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID])
or even:
count({$<[WO Close Date.CalendarMonthNum] = {"<=[WO Required Date.CalendarMonthNum]"}, [WO Responsible Planner]= {'Hartsfield*'},[Asset ID] ={'PS-*'}>} distinct [WO ID])
The syntax is correct. I am not getting an error now. However, this set analysis is not retrieving any data. Thanks for your help.
Thanks for your help Gysbert. The error is gone. However, there is still no data being retrieved with this set analysis.
It needs a value selected in field [WO Required Date.CalendarMonthNum] to work.