I am attempting to divide two columns from as an expression but running into some formatting issues. I attempted using SQL (zero prior knowledge) and my new column does show the result I am looking for but when I kick off a build I receive this error message:
“Inner Exception: Arithmetic overflow error converting nvarchar to data type numeric.”
Would anyone be able to tell me where I am going wrong on my expression?
case when Onhand_Qty = ‘NULL’ then ‘0’ else (convert(decimal(6,2),[Ext_Cost]))/[Onhand_Qty] end