[ABI 5.1] 同比函数-ZF不起作用

你是怎么用的？

主题集有没有设置数据期字段，参考这个帖子http://bbs.esensoft.com/thread-130675-1-1.html

直接用这个函数取主题表字段

设了，在第二个图后边的图就是设置的字段，图有点小

这个过滤条件是干嘛用的？为什么同比增幅还要设置过滤条件，看下你的sql计算详情

是与时间参数和公司参数绑定的

2020-04-21 20:42:18 在并行计算线程池中，开始计算表格GRID40的第1个分析区（0.0.7.9）！
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时3毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as D2,sum(nvl(a.SJJFJ,0)) as D3,sum(nvl(a.JYYCB,0)) as D4,sum(nvl(a.GLFY,0)) as D5,sum(nvl(a.XSFY,0)) as D6,sum(nvl(a.CWFY,0)) as D7,sum(nvl(a.EYYLR,0)) as D8,sum(nvl(a.SLRZE,0)) as D9
from F_LRB_TB a
where ((a.bbq_ >= '201901') AND (a.bbq_ <= '201901') AND (a.userid_ = '10101700'))
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：142毫秒（开始时间：2020-04-21 20:42:18.577；结束时间：2020-04-21 20:42:18.719）；其中生成SQL耗时3毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：137毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时3毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select (case when b.zb1=0 then null else (a.E2-b.zb1)*100.0000/ ABS(b.zb1) end) as E2
from (
select sum(nvl(aa_.YYYSR,0)) as E2
from F_LRB_TB aa_
where ((aa_.bbq_='201901') AND (aa_.userid_ = '10101700'))) a
,(
select sum(nvl(ba_.YYYSR,0)) as zb1
from F_LRB_TB ba_
where ((ba_.bbq_='201901') AND (ba_.userid_ = '10101700'))) b
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：8毫秒（开始时间：2020-04-21 20:42:18.721；结束时间：2020-04-21 20:42:18.729）；其中生成SQL耗时3毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：3毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as F2,sum(nvl(a.SJJFJ,0)) as F3,sum(nvl(a.JYYCB,0)) as F4,sum(nvl(a.GLFY,0)) as F5,sum(nvl(a.XSFY,0)) as F6,sum(nvl(a.CWFY,0)) as F7,sum(nvl(a.EYYLR,0)) as F8,sum(nvl(a.SLRZE,0)) as F9
from F_LRB_TB a
where (a.bbq_='201812')
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：8毫秒（开始时间：2020-04-21 20:42:18.731；结束时间：2020-04-21 20:42:18.739）；其中生成SQL耗时2毫秒；初始获取连接耗时：3毫秒；查询准备总耗时：5毫秒；执行查询sql耗时：1毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as D2,sum(nvl(a.SJJFJ,0)) as D3,sum(nvl(a.JYYCB,0)) as D4,sum(nvl(a.GLFY,0)) as D5,sum(nvl(a.XSFY,0)) as D6,sum(nvl(a.CWFY,0)) as D7,sum(nvl(a.EYYLR,0)) as D8,sum(nvl(a.SLRZE,0)) as D9
from F_LRB_TB a
where ((a.bbq_ >= '201901') AND (a.bbq_ <= '201901') AND (a.userid_ = '10101700'))
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：5毫秒（开始时间：2020-04-21 20:42:18.741；结束时间：2020-04-21 20:42:18.746）；其中生成SQL耗时2毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：0毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select (case when b.zb1=0 then null else (a.E3-b.zb1)*100.0000/ ABS(b.zb1) end) as E3,(case when b.zb2=0 then null else (a.E4-b.zb2)*100.0000/ ABS(b.zb2) end) as E4,(case when b.zb3=0 then null else (a.E5-b.zb3)*100.0000/ ABS(b.zb3) end) as E5,(case when b.zb4=0 then null else (a.E6-b.zb4)*100.0000/ ABS(b.zb4) end) as E6,(case when b.zb5=0 then null else (a.E7-b.zb5)*100.0000/ ABS(b.zb5) end) as E7,(case when b.zb6=0 then null else (a.E8-b.zb6)*100.0000/ ABS(b.zb6) end) as E8,(case when b.zb7=0 then null else (a.E9-b.zb7)*100.0000/ ABS(b.zb7) end) as E9
from (
select sum(nvl(aa_.SJJFJ,0)) as E3,sum(nvl(aa_.JYYCB,0)) as E4,sum(nvl(aa_.GLFY,0)) as E5,sum(nvl(aa_.XSFY,0)) as E6,sum(nvl(aa_.CWFY,0)) as E7,sum(nvl(aa_.EYYLR,0)) as E8,sum(nvl(aa_.SLRZE,0)) as E9
from F_LRB_TB aa_) a
,(
select sum(nvl(ba_.SJJFJ,0)) as zb1,sum(nvl(ba_.JYYCB,0)) as zb2,sum(nvl(ba_.GLFY,0)) as zb3,sum(nvl(ba_.XSFY,0)) as zb4,sum(nvl(ba_.CWFY,0)) as zb5,sum(nvl(ba_.EYYLR,0)) as zb6,sum(nvl(ba_.SLRZE,0)) as zb7
from F_LRB_TB ba_) b
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：6毫秒（开始时间：2020-04-21 20:42:18.748；结束时间：2020-04-21 20:42:18.754）；其中生成SQL耗时2毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：1毫秒；
2020-04-21 20:42:18 在并行计算线程池中，完成计算表格GRID40第1个分析区（0.0.7.9）2020-04-21 20:42:18 在并行计算线程池中，开始计算表格GRID40的第1个分析区（0.0.7.9）！
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时3毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as D2,sum(nvl(a.SJJFJ,0)) as D3,sum(nvl(a.JYYCB,0)) as D4,sum(nvl(a.GLFY,0)) as D5,sum(nvl(a.XSFY,0)) as D6,sum(nvl(a.CWFY,0)) as D7,sum(nvl(a.EYYLR,0)) as D8,sum(nvl(a.SLRZE,0)) as D9
from F_LRB_TB a
where ((a.bbq_ >= '201901') AND (a.bbq_ <= '201901') AND (a.userid_ = '10101700'))
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：142毫秒（开始时间：2020-04-21 20:42:18.577；结束时间：2020-04-21 20:42:18.719）；其中生成SQL耗时3毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：137毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时3毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select (case when b.zb1=0 then null else (a.E2-b.zb1)*100.0000/ ABS(b.zb1) end) as E2
from (
select sum(nvl(aa_.YYYSR,0)) as E2
from F_LRB_TB aa_
where ((aa_.bbq_='201901') AND (aa_.userid_ = '10101700'))) a
,(
select sum(nvl(ba_.YYYSR,0)) as zb1
from F_LRB_TB ba_
where ((ba_.bbq_='201901') AND (ba_.userid_ = '10101700'))) b
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：8毫秒（开始时间：2020-04-21 20:42:18.721；结束时间：2020-04-21 20:42:18.729）；其中生成SQL耗时3毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：3毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as F2,sum(nvl(a.SJJFJ,0)) as F3,sum(nvl(a.JYYCB,0)) as F4,sum(nvl(a.GLFY,0)) as F5,sum(nvl(a.XSFY,0)) as F6,sum(nvl(a.CWFY,0)) as F7,sum(nvl(a.EYYLR,0)) as F8,sum(nvl(a.SLRZE,0)) as F9
from F_LRB_TB a
where (a.bbq_='201812')
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：8毫秒（开始时间：2020-04-21 20:42:18.731；结束时间：2020-04-21 20:42:18.739）；其中生成SQL耗时2毫秒；初始获取连接耗时：3毫秒；查询准备总耗时：5毫秒；执行查询sql耗时：1毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select sum(nvl(a.YYYSR,0)) as D2,sum(nvl(a.SJJFJ,0)) as D3,sum(nvl(a.JYYCB,0)) as D4,sum(nvl(a.GLFY,0)) as D5,sum(nvl(a.XSFY,0)) as D6,sum(nvl(a.CWFY,0)) as D7,sum(nvl(a.EYYLR,0)) as D8,sum(nvl(a.SLRZE,0)) as D9
from F_LRB_TB a
where ((a.bbq_ >= '201901') AND (a.bbq_ <= '201901') AND (a.userid_ = '10101700'))
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：5毫秒（开始时间：2020-04-21 20:42:18.741；结束时间：2020-04-21 20:42:18.746）；其中生成SQL耗时2毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：0毫秒；
2020-04-21 20:42:18 正在生成SQL...
2020-04-21 20:42:18 计算表格GRID40
2020-04-21 20:42:18 生成SQL耗时2毫秒
2020-04-21 20:42:18 当前连接池为【abi_wk】，执行SQL:
select (case when b.zb1=0 then null else (a.E3-b.zb1)*100.0000/ ABS(b.zb1) end) as E3,(case when b.zb2=0 then null else (a.E4-b.zb2)*100.0000/ ABS(b.zb2) end) as E4,(case when b.zb3=0 then null else (a.E5-b.zb3)*100.0000/ ABS(b.zb3) end) as E5,(case when b.zb4=0 then null else (a.E6-b.zb4)*100.0000/ ABS(b.zb4) end) as E6,(case when b.zb5=0 then null else (a.E7-b.zb5)*100.0000/ ABS(b.zb5) end) as E7,(case when b.zb6=0 then null else (a.E8-b.zb6)*100.0000/ ABS(b.zb6) end) as E8,(case when b.zb7=0 then null else (a.E9-b.zb7)*100.0000/ ABS(b.zb7) end) as E9
from (
select sum(nvl(aa_.SJJFJ,0)) as E3,sum(nvl(aa_.JYYCB,0)) as E4,sum(nvl(aa_.GLFY,0)) as E5,sum(nvl(aa_.XSFY,0)) as E6,sum(nvl(aa_.CWFY,0)) as E7,sum(nvl(aa_.EYYLR,0)) as E8,sum(nvl(aa_.SLRZE,0)) as E9
from F_LRB_TB aa_) a
,(
select sum(nvl(ba_.SJJFJ,0)) as zb1,sum(nvl(ba_.JYYCB,0)) as zb2,sum(nvl(ba_.GLFY,0)) as zb3,sum(nvl(ba_.XSFY,0)) as zb4,sum(nvl(ba_.CWFY,0)) as zb5,sum(nvl(ba_.EYYLR,0)) as zb6,sum(nvl(ba_.SLRZE,0)) as zb7
from F_LRB_TB ba_) b
2020-04-21 20:42:18 SQL执行完毕，查询出1条数据，耗时：6毫秒（开始时间：2020-04-21 20:42:18.748；结束时间：2020-04-21 20:42:18.754）；其中生成SQL耗时2毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：1毫秒；
2020-04-21 20:42:18 在并行计算线程池中，完成计算表格GRID40第1个分析区（0.0.7.9）

表样和数据库表方便发一下吗？