This is confusing to me. I am used to If, then statements.
Could someone tell me the error when using this statement. The idea is when the discount level is 0 I want to divide it by 64, if it is not 0 then I want to divide by 24.
This is what I have.
CASE WHEN `Discount`=0 then `Quantity`/ 64 else `Quantity` / 24