| 分母 | 发布版预算 |
|---|---|
| 调整 | 另算调整版 |
| 展示 | 两列并排 |
双版本达成
双版本达成
SELECT b.org_id, b.month,
sum(a.amt) / nullif(sum(b.orig_budget), 0) AS rate_vs_orig,
sum(a.amt) / nullif(sum(b.adj_budget), 0) AS rate_vs_adj
FROM fact_budget b
LEFT JOIN fact_expense a ON a.org_id = b.org_id AND a.month = b.month
WHERE b.month = '2026-09'
GROUP BY b.org_id, b.month;考核与经营分析用哪个分母要事先约定并写入制度。