title: Sharepoint calculated column based on other columns #NULL! error
body: <p>I am trying to add two currency columns in a calculated column but am getting a #NULL! error.</p>
  
  <p>This seems pretty straightforward but its my first time doing this in SharePoint.</p>
  
  <p>SharePoint 2010 with Excel Services available.</p>
  
  <p>Have create List with required columns:</p>
  
  <p>Approved Value column Type = Currency </p>
  
  <p>Pending Value column Type = Currency </p>
  
  <p>Total Value column 
  Calculated (calculation based on other columns) 
  Type = Currency
  Formula: =[Approved Value]+[Pending Value]</p>
  
  <p>The values in other columns are indeed currency, but the Total shows #NULL! for all items.</p>
  
  <p>I can't see anything done incorrectly.</p>
  
  <p>What should I be looking for to resolve this problem?</p>