我已重覆驗證多次，還是找不太出bug是什麼，想請問有經驗的各位

到底是為什麼會在加總後，數值仍舊會少 1 ?!

謝謝

數值驗證正確結果

SQL計算卻少算了1

WITH t1 AS (
SELECT 
X.類別,X.成本,X.目標,X.目標管理職,
SUM(CASE WHEN 階數 = '1' THEN 重計投入 ELSE null END) 投入量1,
SUM(CASE WHEN 階數 = '1' THEN 產出 ELSE null END) 入庫1,
SUM(CASE WHEN 階數 = '2' THEN 重計投入 ELSE null END) 發料量,
SUM(CASE WHEN 階數 = '2' THEN 產出 ELSE null END) 入庫2,
SUM(CASE WHEN 階數 = '2' THEN 回算 ELSE null END) 入庫2回算
FROM table X
LEFT JOIN table D ON X.類別=D.分群

WHERE FACTORY = '' AND 工單別 = '量產' AND 結案日 = to_date('20211111', 'yyyy-MM-dd') GROUP BY X.類別,X.成本,X.目標,X.目標管理職)

,t2 AS (SELECT t1.類別,t1.成本,t1.投入量1,t1.入庫1,t1.發料量,t1.入庫2,t1.入庫2回算,t1.目標,t1.目標管理職,
CASE WHEN NVL(t1.投入量1,0)=0 THEN null ELSE LEAST(t1.入庫1 / t1.投入量1 * 100, 100) END 良率1,
CASE WHEN NVL(t1.發料量,0)=0 THEN null ELSE LEAST((t1.入庫2 - t1.入庫2回算) / t1.發料量 * 100, 100) END 良率2,
CASE WHEN NVL(t1.發料量,0)=0 THEN null ELSE LEAST(t1.入庫2 / t1.發料量 * 100, 100)END  良率2回算
FROM t1)

,t4 AS (SELECT 
t2.品目 品目,
t2.成本 成本,
ROUND(t2.入庫1,0)入庫1,
ROUND(t2.良率1, 2) 良率1,
ROUND(t2.發料量,0)發料量,
ROUND(t2.入庫2,0) - round(t2.入庫2回算,0) 入庫2,
ROUND(t2.良率2, 2) 良率2,
ROUND((t2.良率1 * t2.良率2) / 100, 2) 良率,
ROUND(CASE WHEN NVL(t2.入庫2回算,0)=0 THEN null  ELSE t2.入庫2回算 END) 入庫2回算,
ROUND(t2.良率2回算, 2) 良率2回算,
ROUND((t2.良率1 * t2.良率2回算) / 100, 2) 良率回算,
t2.目標,
t2.目標管理職
FROM t2 )

,t3 AS (
SELECT 
COALESCE(t2.類別, '總良率') 類別,
ROUND(SUM(t2.投入量1), 0) 投入量1,
ROUND ((SUM((t2.成本) * (t2.投入量1) *ROUND((t2.良率1 * t2.良率2) / 100, 2))) / SUM((t2.成本)* round(t2.投入量1,2)),2)良率--總良率計算公式
FROM t2
GROUP BY ROLLUP (t2.類別))

SELECT 
t3.類別,
t4.成本,
t3.投入量1,
t4.入庫1,
t4.良率1,
t4.發料量,
t4.入庫2,
t4.良率2,
t3.良率,
t4.入庫2回算,
t4.良率2回算,
t4.良率回算,
t4.目標,
t4.目標管理職
FROM t3
FULL JOIN t4 ON t3.類別=t4.類別