CASE WHEN ({shipdate} < ({today} +8) AND {custbodyorderonhold} != 'T') THEN 1 ELSE 0 END -> Count for Orders based on ship date and if its not on hold