I am trying to get a value to 2 decimal points but can't get it to work,
this is what i have but no matter where i put convert(decimal(18,2),) it doesn't make a difference.
here is what i have
CASE WHEN COUNT(CUSTOMER_LOG_ID) = 0 THEN 0 ELSE
(CONVERT(decimal(18,2),SUM(case when meet = 1 then 1 else 0 end)) / CONVERT(decimal(18,2),COUNT(CUSTOMER_LOG_ID))) * 100 END as TEST