(SUM(CASE BuyPoint.Match WHEN 'MATCH' THEN 1 ELSE 0 END)/COUNT(BuyPoint.Match ))*100
However, this
was returning 0% as the result. This happens when you have an integer
in a calculation. A very easy fix to this is to multiply by 1.0 (don't use 1, as this will not work. Use 1.0). The updated calculation below works and provides a meaningful result.
((1.0*SUM(CASE BuyPoint.Match WHEN 'MATCH' THEN 1 ELSE 0 END))/(1.0*COUNT(BuyPoint.Match )))*100
No comments:
Post a Comment