Fairly simple here, probably. Percent Goal, Units_data_warehouse, and OEM_Goal are all integers. When I get my output, Percent goal is either 0 or 100. I assume this is because of data types, but every attempt to fix it has resulted in arithmetic overflow or some other error.
SET Percent_Goal = ((Units_Data_Warehouse / OEM_Goal) * 100)