报错如图：字段格式是--> `profitloss_rate` decimal(20,6) DEFAULT NULL COMMENT '损益率',sql是：SELECT
"0011" AS prov_id,#公司编码
"销售公司" AS prov_name,#公司名称
SUM(IFNULL(pre_check_nums,0)) AS pre_check_nums,#预盘数量
SUM(IFNULL(sale_qty,0)) AS sale_qty,#盘点期间销售数影响数
SUM(IFNULL(act_check_nums,0)) AS act_check_nums,#实盘数
SUM(IFNULL(profitloss_nums,0)) AS profitloss_nums,#盈亏数
SUM(IFNULL(profitloss_amt_withtax,0)) AS profitloss_amt_withtax,#盈亏金额(含税)
SUM(IFNULL(profitloss_amt,0)) AS profitloss_amt,#盈亏金额(不含税)
profitloss_rate #损耗率
FROM app_bi_noil_profitloss
where
1=1
AND BUSINESS_MONTH = replace('${CNDSTARTDATE}',"-","")
and prov_id = '0011'
AND AREA_ID = '0'
AND ORGANISE_ID = '0'
${IF(CNDPROVINCE = '0011',"",IF(LEN(CNDPROVINCE)=0,"","AND PROV_ID = '"+CNDPROVINCE+"'"))}
${IF(LEN(cndQcode_S)=0,"AND 1=1","AND PROV_ID=
(CASE WHEN '"+cndQcode_S+"' IN ('000111','000112','000105') THEN 'CB0002' WHEN '"+cndQcode_S+"' IN ('000103','000110') THEN 'CB0001'
ELSE '"+cndQcode_S+"' END)")}
