title: How to add a conditional grand total in Crystal Reports?
body: <p>I have a group running total that needs to be sum up at the report footer. Since thats not possible with CR I had to end up having another running total that refreshes "Never". But now I need to calculate some percentages at the group level based on this Grand total. Unfortunately I cannot access the value for grand total (because its another running total).
  Confused?? Ok reports should look like below..</p>
  
  <hr>
  
  <pre><code>    Column 1                           | Colunm 2
      ========                            ========= 
  </code></pre>
  
  <hr>
  
  <p>| Group   200 (Running Total Refresh at Group level)  | 20% (200%1000) |<br>
  | Group   500 (Running Total Refresh at Group level)  | 50% (500%1000) |<br>
  | Group   300 (Running Total Refresh at Group level)  | 30% (300%1000) |</p>
  
  <hr>
  
  <p>Footer  1000 (Running Total Never Refreshed)</p>
  
  <hr>
  
  <p>But column 2 doesn't give me the correct value. it gives me 100% always means 200%200 or 500%500 etc.</p>
  
  <p>Any idea how to fix this??</p>