title: The value of '' cannot be converted to a number
body: <p>I have the following query:</p>
  
  <pre><code>&lt;cfset x = 0.125&gt;
  
  &lt;cfquery name="MySummary" datasource="xyz"&gt;
          SELECT 
            sum(mycount_int_int) * 2 AS MySummary
          FROM
               [MK].[dbo].[mytable] 
          WHERE
              date_dt  &gt;= '#Start_dt# #Start_time#' AND date_dt &lt; '#Stop_dt# #Stop_time#' 
  
  
      &lt;/cfquery&gt;
  </code></pre>
  
  <p>And I am getting the following error :</p>
  
  <pre><code>The value of '' cannot be converted to a number.
  </code></pre>
  
  <p>The error occured in Line 241</p>
  
  <p>Here is my line 241 which is written below the above cfquery in my code:</p>
  
  <pre><code>&lt;cfset Voice1st = Numberformat(MySummary.MySummary * x, "0.00")&gt;
  </code></pre>
  
  <p>Should I do something like the following?</p>
  
  <pre><code>&lt;cfset Voice1st = IsNumeric(Numberformat(MySummary.MySummary * x, "0.00"))&gt;
  </code></pre>
  
  <p>Please let me know</p>