Hi experts!
i want to make this query works
but i tried many different ways but still it do not work!
and error said like this
maybe After "THEN" Should be Column from Table?
case when T1."Account" =42001000 AND T1."ProfitCode"= 40908050 THEN 1
when T1."Account" =47203000 AND T1."ProfitCode"= 40908050 THEN 1
when T1."Account" =47214000 AND T1."ProfitCode"= 40908050 THEN 1
when SUBSTR(T1."ProfitCode" , 5) =40904 OR SUBSTR(T1."ProfitCode" , 5) = 40906 THEN 12
ELSE 50
END AS "Category"
- SAP Managed Tags:
Accepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 84 | |
| 9 | |
| 9 | |
| 8 | |
| 7 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.