[ABI 5.1] 为什么计算之后没有结果值呢

@lx是什么意思，@lx是主题表字段或者是sql数据源名吗@lx的浮动范围是不是把后面的sum也括进去了

@lx是查询条件中类型参数框
对,@lx把整行都包裹进去了,sum不包括的话,会报错

就是因为包括进去所以才会没数据的，

截图202101281454578737.png (17.02 KB, 下载次数: )

下载附件

2021-1-28 14:54 上传

不包括的话,会报这个错误

表样导出我看一下

没有权限

那看下报错详情

2021-01-28 15:46:30 开始计算报表：Comparison_of_customer_source_data（内存情况：FREE=301.7M TOTAL=2G MAX=3.6G）
2021-01-28 15:46:30 引用的主题表： 客房经营汇总分析
2021-01-28 15:46:30 查询的数据级次范围：没有做限制。
2021-01-28 15:46:30 001开始多表格各分析区并行计算
2021-01-28 15:46:30 [GRID4(0.0.2.2)]正在生成SQL...
2021-01-28 15:46:30 [GRID2(0.0.2.2)]正在生成SQL...
2021-01-28 15:46:30 [GRID3(0.0.2.2)]正在生成SQL...
2021-01-28 15:46:30 [GRID2(0.0.2.2)]计算表格GRID2
2021-01-28 15:46:30 [GRID2(0.0.2.2)]生成SQL耗时17毫秒
2021-01-28 15:46:30 [GRID4(0.0.2.2)]计算表格GRID4
2021-01-28 15:46:30 [GRID4(0.0.2.2)]生成SQL耗时17毫秒
2021-01-28 15:46:30 [GRID3(0.0.2.2)]计算表格GRID3
2021-01-28 15:46:30 [GRID3(0.0.2.2)]生成SQL耗时19毫秒
2021-01-28 15:46:30 [GRID2(0.0.2.2)]当前连接池为【abitest】，执行SQL:
select row_.*,rownum from ( select sum(a.ROOM_NIGHTS) as B2,a.BIZ_DATE as A2,max(b.DATENAME) as mc_A20
from HKJD_EDW_ROOM_SUM a
,HKJD_DIM_DATE b
where (TO_CHAR(A.BIZ_DATE,'yyyymmdd')=B.DATESTR(+))
group by a.BIZ_DATE )row_ where rownum <= 1000
2021-01-28 15:46:30 [GRID4(0.0.2.2)]当前连接池为【abitest】，执行SQL:
select row_.*,rownum from ( select sum(a.ROOM_INCOME) as B2,a.BIZ_DATE as A2,max(b.DATENAME) as mc_A20
from HKJD_EDW_ROOM_SUM a
,HKJD_DIM_DATE b
where (TO_CHAR(A.BIZ_DATE,'yyyymmdd')=B.DATESTR(+))
group by a.BIZ_DATE )row_ where rownum <= 1000
2021-01-28 15:46:30 [GRID3(0.0.2.2)]当前连接池为【abitest】，执行SQL:
select row_.*,rownum from ( select max((case when a.ROOM_NIGHTS = 0 then NULL else a.ROOM_INCOME/a.ROOM_NIGHTS end)) as B2,a.BIZ_DATE as A2,max(b.DATENAME) as mc_A20
from HKJD_EDW_ROOM_SUM a
,HKJD_DIM_DATE b
where (TO_CHAR(A.BIZ_DATE,'yyyymmdd')=B.DATESTR(+))
group by a.BIZ_DATE )row_ where rownum <= 1000
2021-01-28 15:46:30 [GRID2(0.0.2.2)]SQL执行完毕，查询出40条数据，耗时：25毫秒（开始时间：2021-01-28 15:46:30.780；结束时间：2021-01-28 15:46:30.805）；其中生成SQL耗时17毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：5毫秒；
2021-01-28 15:46:30 [GRID4(0.0.2.2)]SQL执行完毕，查询出40条数据，耗时：26毫秒（开始时间：2021-01-28 15:46:30.780；结束时间：2021-01-28 15:46:30.806）；其中生成SQL耗时17毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：5毫秒；
2021-01-28 15:46:30 [GRID3(0.0.2.2)]SQL执行完毕，查询出40条数据，耗时：27毫秒（开始时间：2021-01-28 15:46:30.780；结束时间：2021-01-28 15:46:30.807）；其中生成SQL耗时19毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：6毫秒；
java.lang.NullPointerException
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.GroupOlapAnalyseInFxq.autoNameChildAnalyse(GroupOlapAnalyseInFxq.java:344)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.GroupOlapAnalyseMakerByLinkExp.makeGroupOlapAnalyse(GroupOlapAnalyseMakerByLinkExp.java:88)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.GroupOlapAnalyseMakerByLinkExp.makeOlapAnalyse(GroupOlapAnalyseMakerByLinkExp.java:137)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.GroupInnerAnalyseMaker.makeOlapAnalyse(GroupInnerAnalyseMaker.java:91)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.FixRectsGroupInnerAnalyseMaker.makeOlapAnalyse(FixRectsGroupInnerAnalyseMaker.java:37)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.CustomGroupAnalyseMaker.makeASingleOlapWithCondition(CustomGroupAnalyseMaker.java:171)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.CustomGroupAnalyseMaker.makeAnalyses(CustomGroupAnalyseMaker.java:95)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.anamaker.FloatFxqAnalyseMaker.makeAnalyses(FloatFxqAnalyseMaker.java:64)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.createAnaObjs(FloatFxqCalc.java:90)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:78)
at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)
at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:107)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

不像是sum引起的报错{:3_57:}

那是怎么回事呢{:3_43:}