Count distincvt if 3 conditions are met in set analysis
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)