PIDM DAT PERC COL1
1 4/1/2018 7 21.4
1 4/2/2018 9 Value2
1 4/3/2018 5 Value3
我需要价值2增加9%21.4,价值3增加5%
有什么想法吗?
发布于 2018-07-26 15:43:36
你需要将1添加到PERC列,因为你希望增加一个百分比,而不是原始值的一个百分比。
使用Gordon的第二个查询,只需一个小的tWeek就可以得到你想要的结果:
select t.*,
(first_value(col1) over (partition by pidm order by dat) *
exp(sum(ln(1+perc / 100.0)) over (partition by pidm order by dat) -
first_value(ln(1+perc / 100.0)) over (partition by pidm order by dat)
)
) Results
from t;
发布于 2018-07-26 16:35:34
如下所示:
select t.*,
(first_value(col1) over (partition by pidm order by date) *
exp(sum(ln(1 + perc / 100.0)) over (partition by pidm order by date))
)
from t;
select t.*,
(first_value(col1) over (partition by pidm order by date) *
exp(sum(ln(1 + perc / 100.0)) over (partition by pidm order by date) -
first_value(ln(1 + perc / 100.0)) over (partition by pidm order by date))
)
)
from t;
https://stackoverflow.com/questions/-100005815
复制相似问题