title: Calculated field returning #Type error
body: <p><strong>Small pizzas cost £6.00</strong> and all <strong>toppings are £1.50</strong>. I have created a <strong>calculated field</strong> that should <strong>add up</strong> the cost of the small pizza and the topping to get the <strong>total amount</strong>. This is returning the value <strong>#Type!</strong> even after changing the result type of the calculated field. </p>
  
  <p>I am trying to <strong>add up</strong> the values within the textbox (which uses the 'Lookup' data type to store the values within a drop down box) to calculate a total cost for the order.</p>
  
  <p>Any solutions?</p>
  
  <p><a href="http://i.stack.imgur.com/Unvz8.png" rel="nofollow">Calculated field expression and result type</a></p>
  
  <p><a href="http://i.stack.imgur.com/cz0in.png" rel="nofollow">Order form</a></p>