在设置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函数中应该怎么写

建议你把 fformula = '=BgItem("607.01","2016Y","07","BgData",true,"BB01")' 函数放在另外一个单元格，然后设置你的sql的where条件=fformula函数所在的单元格
不这样写，无法弄，因为一个是查询数据库，一个是系统的函数，kPGetSql函数只能调用数据库查询语句
:L，问的太专业了，纯业务人员表示看不懂