WhenI try to run this code:
`SELECT CASE WHEN a.promotionflag=0 THEN 'NoPromotion' WHEN (Sales)/ISNULL(Margin,0) > -3.0000 AND (Sales)/ISNULL(Funding, 0) < 0 THEN 'RED' WHEN (Sales) <0 THEN 'RED' WHEN (Sales)= 0 and (Margin) <0 then 'RED' WHEN (Sales)/ISNULL(Margin, 0) >= 0 THEN 'GREEN' WHEN (Sales) IS NULL THEN 'NonPriority' WHEN (Margin) IS NULL THEN 'NonPriority' ELSE 'YELLOW' END AS Promotions`
I receive an error that says "incorrect syntax near >" and brings me to the first instance where there is a >. Then when I hover about that, the first time I received the error it also mentioned a "boolean function."
I want this code to return me the color values based on the above criteria.