帮助文档上面写的是用公式计算今年某月同比去年对应月份的数据，但是如果我想要参数控件筛选的时间段的同比呢？
with t1 as
(select sum(amount) amount from dual
where fdate between '${start_date }' and '${end_date}'),
t2 as
(select sum(amount) amount_last_year from dual
where fdate between to_date('${start_date }', 'yyyyMM') + interval '-1 year' and to_date('${end_date}', 'yyyyMM') + interval '-1 year')
select (amount-amount_last_year)/amount_last_year 同比 from t1
left t2 on 1=1
1min目标场景问卷
立即参与
