case when t3.main_machine_prodt_schedule_qty_cumulative = 0 then '0.0%' else (concat(round(((t3.main_machine_prodt_schedule_qty_cumulative*1.0)/t3.prodt_schedule_qty_cumulative),2)*100,'%')) end as cumulative_ratio_percent
试试
-------
case when t3.main_machine_prodt_schedule_qty_cumulative = 0 then '0.0%' else (concat(round(((t3.main_machine_prodt_schedule_qty_cumulative*100)/t3.prodt_schedule_qty_cumulative),2),'%')) end as cumulative_ratio_percent
----------
case when t3.main_machine_prodt_schedule_qty_cumulative = 0 then '0.0%' else
(concat(convert(nvarchar(100),round((t3.main_machine_prodt_schedule_qty_cumulative/t3.prodt_schedule_qty_cumulative),2)*100)),'%'))
end as cumulative_ratio_percent