We are building a saved search to show all the manufacturing operations tasks per work order when drilled down but only show the CURRENT manufacturing operation task at summary level. Current manufacturing operation task is the latest operation task where completed quantity > 0. However, if all of the completed quantity = 0, then it should show the 1st step (1st operation task). All first operation tasks have a sequence number of 10. Basically, this is the operations task that the work center is currently working on. Is this possible? I tried to use Max and formula fields but none of them worked.