嗨，我正在尝试的情况下，但它不工作的情况下。它在执行时返回相同的语句

Question

whenActual周转时间大于TAT值，那么我希望它结束。

CASE(WHEN TAT = 3 AND  [Actual turn around time] > 3 THEN 'Over' 
     WHEN TAT = 7 AND  [Actual turn around time] > 7 THEN 'Over' 
     WHEN TAT = 14 AND  [Actual turn around time] > 14 THEN 'OVER'
     WHEN TAT = 28 AND  [Actual turn around time] > 28 THEN 'Over'
     WHEN TAT = 42 AND  [Actual turn around time] > 42 THEN 'Over'
     WHEN TAT = 52 AND  [Actual turn around time] > 52 THEN 'Over'
     WHEN TAT = 56 AND  [Actual turn around time] > 56 THEN 'Over'
     WHEN TAT = 62 AND  [Actual turn around time] > 62 THEN 'Over'
     WHEN TAT = 84 AND  [Actual turn around time] > 84 THEN 'Over'
     WHEN TAT = 112 AND  [Actual turn around time] > 112 THEN 'Over')
     ELSE 'TEST'
     END AS 'ITAT'

Answer 1

为什么不简化一下逻辑呢？

(CASE WHEN [Actual turn around time] > TAT THEN 'Over' 
      ELSE 'TEST'
 END) AS ITAT

您的代码中有一个放错位置的圆括号。

如果您希望将逻辑限制为TAT的特定值，则将条件扩展为：

(CASE WHEN [Actual turn around time] > TAT AND
           TAT IN (3, 7, 14, . . . )
      THEN 'Over' 
      ELSE 'TEST'
 END) AS ITAT