title: SSRS Aggreation on Calculated Field
body: <p>I am trying to perform an aggregation on a calculated Field in SSRS and am getting the following error:</p>
  
  <blockquote>
    <p>[rsAggregateReportItemInBody] The Value expression for the textrun 'Textbox43.Paragraphs[0].TextRuns[0]' uses an aggregate function on a report item.  Aggregate functions can be used only on report items contained in page headers and footers</p>
  </blockquote>
  
  <p>This is the formula I tried to use:</p>
  
  <pre><code>=Sum(ReportItems!PlanPurchPrice.Value, "Select_UCPUtilization")
  </code></pre>
  
  <p>In this Case PlanPurcPrice is also an Expression:</p>
  
  <pre><code>=First(Fields!PawPlanPurchPrice.Value, "Select_UCPUtilization")
  </code></pre>
  
  <p>Any suggestions on this would be greatly appreciated.</p>