Anyone able to help me with CASE WHEN logic. I get...
# suiteanalytics
p
Anyone able to help me with CASE WHEN logic. I get an error but cant see why...
Copy code
CASE WHEN {totalprice}/({price}*{quantity}) THEN      '<div style="color:black;background-color:#CCB114;padding:5px;text-align:center;">' || 'ERROR' ELSE   '<div ></div>'     END
k
You've got a possible divide by zero
also what is your formula comparing to?
total price / price * quantity equal to what?
p
@KevinJ of Kansas ha good spot. I'd been staring at it for so long I couldn't see the error! Thanks