>select count( case when mytable.myfield = 0 then 0 else distinct( mytable.myfield ) end ) as TotCount >>
select count( distinct( case when mytable.myfield!=0 then myTable.myField end ) ) as TotCount -- this count will exclude the 0 orders from the count (as this case is no NULL and NULL is excluded from the count)