select ${if(len(mendian) == 0,if(len(yuefen) == 0,"left(年月,4) 时间,一级,价格段,","left(年月,7) 时间,一级,价格段,"),if(len(yuefen) == 0,"left(年月,4) 时间,门店,一级,价格段,","left(年月,7) 时间,门店,一级,价格段,"))}

  sum(销售收入)/10000 销售收入,

  sum(销售成本)/10000 销售成本,

  sum(销售毛利)/10000 销售毛利,

  sum(优惠金额)/10000 优惠金额

from dw_品类价格段数据

where left(年月,4)='${shijian}' 

and 一级='${pinlei}'

${if(len(yuefen) == 0,"","and  right(年月,2) in ('" + yuefen + "')")}

${if(len(mendian) == 0,"","and 门店 in ('" + mendian + "')")}

${if(len(jiageduan) == 0,"","and 价格段 in ('" + jiageduan + "')")}

${if(len(mendian) == 0,if(len(yuefen) == 0,"group by left(年月,4),一级,价格段","group by left(年月,7),一级,价格段"),if(len(yuefen) == 0,"group by left(年月,4),门店,一级,价格段","group by left(年月,7),门店,一级,价格段"))}

${if(len(mendian)=0&&len(yuefen)=0,"group by left(年月,4),一级,价格段",if(len(yuefen)!=0,"group by left(年月,7),一级,价格段",if(len(mendian)!=0&&len(yuefen)=0,"group by left(年月,4),门店,一级,价格段",if(len(yuefen)=0,"group by left(年月,7),门店,一级,价格段",""))))}

你月份怎么会有两个不为空的情况哦