title: Crystal Reports Formula Variable Passing
body: <p>I am working on this report pulls all of our Projected Purchases grouped by Month displaying a sum (called <code>"Monthly_Total"</code> for the month as well as displays the Budget (called <code>"Monthly_Budget"</code> for the month. I also have a subreport that I use a shared currencyvar <code>"Starting_Balance"</code>. This shared variable updates whenever the report is run.
   I need to find a way to do the following calculation:</p>
  
  <p>for the first month (in this case the report starts with March) it should be </p>
  
  <pre><code>"Starting_Balance" + "Monthly_Total") - "Monthly_Budget" = "New_Balance"
  </code></pre>
  
  <p>each subsequent Month would use the formula</p>
  
  <pre><code>("New_Balance" + "Monthly_Total") - "Monthly_Budget"
  </code></pre>
  
  <p>I can get it to work for the first group footer, but with then each month after that is referencing back to the <code>"Starting_Balance"</code> rather than the <code>"New_Balance"</code></p>
  
  <p>any ideas?</p>