10 Replies Latest reply: Dec 27, 2011 8:50 PM by Jonathan Love RSS

    Count distincvt if 3 conditions are met in set analysis

    Jonathan Love

      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)