RM 报表, ,同比是后台数据库中存好的两个字段,我直接拿过来做了计算,sql如下:
select dateid as 统计日期,
b.comcode4 as 四级机构名称,
classcode as 险类,
agentcode as 大渠道,
sum(BFSR_CNY) as 保费收入,
round(decode(SUM(BFSR_CNY_TQ),0,0,(sum (BFSR_CNY)-sum(BFSR_CNY_TQ))/sum(BFSR_CNY_TQ)),4)as 同比,
sum(ysbf_cny) as 当年应收保费,
sum(yjjs) as 已决件数,
round(decode(SUM(YJJS_TQ),0,0,(sum(yjjs)-sum(YJJS_TQ ))/sum(YJJS_TQ)),4) as 已决件数同比,
sum(yjpk_cny) as 已决金额,
round (decode(SUM(YJPK_CNY_TQ),0,0,(sum(YJPK_CNY)-sum(YJPK_CNY_TQ))/sum(YJPK_CNY_TQ)),4) as 已决金额同比 ,
sum(wjjs) as 未决件数,
round(decode(SUM(WJJS_TQ),
0,
0,
(SUM(wjjs) - sum(WJJS_TQ)) / SUM(WJJS_TQ)),
4) as 未决件数同比,
sum(wjpk_cny) as 未决金额,
round(decode(sum(WJPK_CNY_TQ),0,0,(sum(wjpk_cny)-sum(WJPK_CNY_TQ))/sum(WJPK_CNY_TQ)),4) 未决金额同比
from user_dma.DMA_DEP_IT_001 a
inner join user_dma.d_org b on a.comcode = b.comcode
group by dateid, b.comcode4, classcode, agentcode
可是出来的同比结果都是百分之好几百,而且大的离谱,不知道是为什么啊???
附件:
UM2009_4133864398.rtf (416.3 KB)