select t.bic_mzxnjg,t.mmzecfl1,t.khfl1_txt,t.mmzecfl2,t.khfl2_txt,t.mmm_ypdl,t.mmmbwcs2,t.jsl-t.jhl as kcl from(

SELECT  bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2,sum(msdjsqty)/count(doc_num) AS jsl,sum(nvl(act_dl_qty,0)) AS jhl,sum(subtot_oc1)/count(doc_num)AS jsje from app_yc.yc_kcl_orc

where jsdat <= '2022-12-22'

${IF(FIND("11",tjgz) !=0," AND (mmmzecfl1 IN ('A02','A05','A03') or mmmzecfl1 is null) ","")}

${IF(FIND("12",tjgz) !=0," AND mmmzecfl1 IN ('B05','A01')","")}

${IF(FIND("13",tjgz) !=0," AND mmmzecfl1 ='B01' ","")}

${IF(FIND("14",tjgz) !=0," AND mmmzecfl1 IN ('B04','B06')","")}

${IF(FIND("15",tjgz) !=0," AND mmmzecfl1 IN ('B03','B07','B02')","")}

GROUP BY  bic_mzxnjg,mmzecfl1,khfl1_txt,mmzecfl2,khfl2_txt,mmm_ypdl,mmmbwcs2

)t

------------------------

日志简介-https://help.fanruan.com/finereport/doc-view-991.html

-- 传递参数后，定位SQL脚本。

先说 报什么错

空指针错误-https://help.fanruan.com/finereport/doc-view-386.html

是否是字符需要转译的问题。