5 Replies Latest reply: Apr 1, 2014 1:39 PM by Jeremiah Kurpat RSS

    Distinct Count with If

      Hi All,

       

      I am struggling to convert the expression =Count(If(Enroute>=0,[Truck Reg],0)) into one which produces a distinct count of the field Truck reg whenever the condition Enroute>=0 is met.

       

      Can someone assist with a tweak.

       

      Thanks