报错如图：字段格式是--> `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)")} |
1min目标场景问卷
立即参与
