KPGetSql公式使用
1,685次浏览
编辑于2016年07月29日 15:41:07
在设置KPGetSql公式使用如下语句:
KPGetSql("select sum(fbizactual) fbizactual from T_BG_BgActualdata
where fformula = '=BgItem("607.01","2016Y","07","BgData",true,"BB01")'
and fBgActualRecordid in (select fid from T_BG_BgActualRecord where FBgPeriodID in (select fid from T_BG_BgPeriod where fnumber='2016Y.06M'))
and forgunitid in (select fid from T_ORG_BaseUnit where fnumber='410305')","DECIMAL","fbizactual","")
系统提示公式有错误,后经过排查发现是第一个过滤条件的问题,请教像 fformula = '=BgItem("607.01","2016Y","07","BgData",true,"BB01")' 这种过滤条件在KPGetSql函数中应该怎么写
推荐阅读