why is this causing a divide by 0 error???
update #totals
set units_cancel_percent = units_sent/units_cancelled
in my temp table I am trying to divide the results of these two colums by each other in an update statement; how can I do this????
Printable View
why is this causing a divide by 0 error???
update #totals
set units_cancel_percent = units_sent/units_cancelled
in my temp table I am trying to divide the results of these two colums by each other in an update statement; how can I do this????
Maybe?
update #totals
set units_cancel_percent = units_sent/units_cancelled
where units_cancelled not null and units_cancelled<> 0
yes, that works