title: SSRS 2008 R2 - Resetting the runningvalue when a specific row is returned
body: <p>I have a report that returns sales data. The report has a quantity column and a running total column that i calculate by using the SSRS Running Value.</p>
  
  <p>E.G.:</p>
  
  <pre><code>=RunningValue(Iif(Fields!iType.Value = 6, 0, Fields!iQuantity.Value), Sum, Nothing)
  </code></pre>
  
  <p>I am trying to reset this running value back to the quantity when the iTypeID (transaction type) = 6. </p>
  
  <p>I have tried the switch option, various if statements however i cannot get the outcome i need. </p>
  
  <p>Rather difficult to explain without being able to post a screen shot / image of my issue.</p>