Setting numeric format on a subtotal

[ifntech]

I'm subtotalling in SQL Server in a query and then post that to a graph.
The graph is saying it is not a number value.
What is the sql code to set the "sum(value) as totalvalue" to a numeric type.

Thanks Dan

 

[Cheech]

(sum(value) as totalvalue) as numeric

[Peace][Pipe]

 

[ifntech]

I get an "incorrect syntax error near keyword as" now with that change

 

[ifntech]

I got this to run
convert(numeric(12,2),SUM(fieldname)) AS Number1


but when I try to calc off of two of them.

<% comp=((macro.table("Number1").value)/(macro.table("Number2").value))%>
<%=comp%>

I get a Microsoft VBScript runtime error '800a000d'
Type mismatch
error