title: SQL Conversion failed when converting the varchar value to data type numeric
body: <p>I'm having some difficulty with the following SQL query:</p>
  <pre><code>SELECT
      SUM(ArTrnDetail.NetSalesValue) AS [Price],
      'ExecuteSubReport(813, 0, Job)' AS [LaborCost],
      'ExecuteSubReport(815, 0, Job)' AS [MaterialCost],
      'ExecuteSymbolicMath(LaborCost + MaterialCost)' AS [TotalCost],
      'ExecuteSymbolicMath(Price - (LaborCost + MaterialCost))' AS [Margin],
      CASE 
          WHEN SUM(ArTrnDetail.NetSalesValue) = 0 
              THEN 0
              ELSE 'ExecuteSymbolicMath(1 - (TotalCost / Price))'  &lt;-- Where it's failing
      END AS [MarginPct]
  </code></pre>
  <p>The <code>ExecuteSubReport</code> and <code>ExecuteSymbolicMath</code> are company functions. The <code>ExecuteSymbolicMath</code> basically strips unwanted chars like $ and commas, does the math and returns the result as a string. The end result for the column being a decimal(2 places) between 0-1. When I try to run the query I get an error saying that it can't convert varchar to numeric. I've tried just about everything I can think of. I've tried replace, convert, cast, str.</p>
  <p>Thank you very much for your help!</p>