title: SSRS Expression - Subtract SUMS
body: <p>I need some help with an SSRS expression that sums up amounts and then subtracts sums. I have a dataset that has accounts and corresponding money/amount values. I'm trying to write an expression that sums up the money/amount values from one group of the accounts in a specified range, and then subtracts it from the money/amount total of another range. For example:</p>
  
  <pre><code>(Sum(amt) where acct between 40000 and 49999) - 
  (Sum(amt) where (acct between 50000 and 59999) or (acct between 66000 and 69999)) - 
  (Sum(amt) where acct between 76000 and 79825) - 
  (Sum(amt) where acct between 89000 and 90399) 
  </code></pre>
  
  <p>I could really use some help translating the SQL logic above into an expression to be used for a textbox in SSRS. Any advice would be really helpful! Thanks!</p>