Please see example below of the CASE statements: sum(case when <<root.product>> in ('VD', 'VN', 'DM','PD','4PR','UN','ID','LT','N','IN') then 1 else 0 end) What is the difference between having the 'sum' at the front or not having it at the front? Thanks
... View more