Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to know how many unique "Service_Order_Number" exist if the "expense_type' = labor, the "...type_description" = "travel_time", and the the amount of travel time ("invoiced_qty...") is equal to zero. Basically, unique service calls that have no travel time invoiced against them. I get no returns? =COUNT({$}DISTINCT Service_Order_Number)
Actually it works - thanks again