Case When

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

Thanks!

Find more posts tagged with

Comments

ST_Superman

Every case statement needs to finish with an end statement:

CASE WHEN `Discount`=0 then `Quantity`/ 64 else `Quantity` / 24 END

You will also need to make sure that the `Discount` field is a numeric field. If it is text, then you will need to do:

CASE WHEN `Discount`='0' then `Quantity`/ 64 else `Quantity` / 24 END

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of