I have tried wrapping the statement into a Sum statement as well as a Count statement but then it just sums it or does a count. I need it to be a number.
SUM(CASE
WHEN `Column_1` = 'Value_1’
THEN SUM(`Column_1`)
END)
When I use the above it sums the numbers and I just need it to give.
(CASE
WHEN `CustomerName` LIKE'%AGRODEX INTERNATIONAL SAS%' THEN ('.14')
wHEN `CustomerName` LIKE'%ALTURISA GUATEMALA%' THEN ('.14')
WHEN `CustomerName` LIKE'%ANGLISS HONG KONG%' THEN ('3')
WHEN `CustomerName` LIKE'%BEN FOOD%' THEN ('3.20')
WHEN `CustomerName` LIKE'%BENISAND MERCHANDISING%' THEN ('5')
WHEN `CustomerName` LIKE'%BIGOS S DE RL%' THEN ('.15')
ELSE ('0') END)