select attribute3,sum(amount) from dwd_yuntu_kcjkfx 

where 1=1 

${if(p_received_date_begin = "","","and received_date >= '" + p_received_date_begin + "'")}

  ${if(p_received_date_end = "","","and received_date <= '" + p_received_date_end + "'")}

  ${if(p_received_year="","","and received_year in('"+replace(p_received_year,",","','")+"')")}

      ${if(p_received_month="","","and received_month in('"+replace(p_received_month,",","','")+"')")}

      ${if(p_received_quarter="","","and received_quarter in('"+replace(p_received_quarter,",","','")+"')")}

      ${if(p_description="","","and description in('"+replace(p_description,",","','")+"')")}

--

${if(p_responsible_department="","","and responsible_department in('"+replace(p_responsible_department,",","','")+"')")}

      ${if(p_product_name="","","and product_name in('"+replace(p_product_name,",","','")+"')")}

      ${if(p_attribute3="","","and attribute3 in('"+replace(p_attribute3,",","','")+"')")}

${if(p_product_xl="","","and product_xl in('"+replace(p_product_xl,",","','")+"')")}

      ${if(p_last_name="","","and last_name in('"+replace(p_last_name,",","','")+"')")}

group by attribute3

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

问题定位：

好多，建议注释掉一些条件，一个一个测试

改一下这个 in ('"+SUBSTITUTE(p_last_name,",","','")+"')