-
SQL CASE statement question
Hi guys, I'm having an issue with this lines of code.
I'm trying to calculate or multiply numbers from .01 to .04 by .25 and anything above .04 is multiplied by 1. It works when I mutiply a number higher that .04 for example .05 it multiplies it by .01 but anything below .05 does not get multiplied by .25. Can somone please help? Thanks!
Heres the what I have:
This is the new one
CASE WHEN curOther > .039 THEN curOther + .01 ELSE (curOther * .25) + curOther END
This is the original
CASE WHEN curOther > .04 then .01 ELSE curOther * .25 + curOther END
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|