Joseph Lee
Watz
count(distinct case when {item.custitem_tss_inventory_rank} = 'New' THEN {item.id} Else null End)