Formula tool format result as number

[parria1]

I am creating a custom field by dividing my current fields [net]/[qty] to get the new PPT field.

The net and qty are both doubles format but for some reason the PPT is coming out as a V_Wstring which is not logical and I cannot do further calculating from this as it is not a number.

Is there a way to format my functions so the result is a number, like the CAST as DOUBLE function is SQL?

I tried ToNumber([net]/ToNumber[qty] and the result is still a string.

I know I can put in a select tool after the formula tool and change all these to doubles, but I'm looking for a way to do this inside the formula since it is more efficient. 

[ponraj · Accepted solution]

Formula tool has the option for changing output data type for the new field you create. 

[ThizViz]

Yep, forgetting that little detail has bitten me on more than one occasion!