CASE WHEN max(B.target) IS NULL THEN 1 WHEN max(notax_unitpce_amount) IS NULL THEN 0 ELSE max(notax_unitpce_amount)/10000 / ${if(len(p_type1) = 0 ,"max(B.target)", "(max(B.target)/day(EOMONTH('"+p_start_date+"'))-dbo.f_get_holidays('"+p_start_date+"','"+p_end_date+"','N','%','WYSY')) "))} END 达成率 |
1min目标场景问卷
立即参与
