title: Create summary in report footer by omitting suppressed records
body: <p>I have a group header section in a report which displays a summary total from a formula field called Personal,</p>
  
  <pre><code>if not IsNull({AirBilling.BillingCode}) and {AirBilling.BillingCode} = 'P' then
      {AirBilling.Gross}
  else
      0
  </code></pre>
  
  <p>Now at the end of the report in the Report footer I display a summary total of all the Personal totals calculated in the group header section. Now I have a subreport that filters certain records and depending on the count returned by the subreport, I suppress records in my main report. My problem is that, my main report considers counts of suppressed records also in the Footer total. When I try to put a condition in formula field logic above that says if RowCount>0 then..(if not IsNull....), but when I try to run the report it gives me an error that says 'A summary has been specified on a non-recurring field'. Is there a way I can omit the suppressed records to be calculated in the footer section. RowCount is the shared variable value returned by subreport which I am using to filter records in main report.</p>