Suppressed Data being calculated on a count
<p><a href="https://i.stack.imgur.com/uMOyH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uMOyH.jpg" alt="enter image description here"></a>I am trying to get a count of records for a the <code>Charge Group</code>; however it is counting my suppressed data as well. I understand that suppressed data is only hidden and doesn't effect any calculation, but how can I adjust my formula so it doesn't take the suppressed data. </p>

<p>I attempted to do a running total field however I receive an error </p>

<pre><code>A running total cannot refer to a print time formula Details: @Customer Drop Max Amount
</code></pre>

<p>Within the report there are multiple <code>Trailer Charge Groups</code> that are basically shippers and their destinations are marked as <code>Drop Customers</code></p>

<p>I only want one record for two <code>Drop Customers</code> to be computed, so whenever another trailer falls into the record for <code>Drop Customer</code> I have to change the count field to show that their should only be one. </p>

<p>The formula field I am doing that for is <code>Charge group count</code></p>

<pre><code>IF {@TRAILER CHARGE GROUP} = 'INTCNEWNC' THEN Count ({TRAILER_CUSTOMER_ZONE.TRAILER_ID} , {@TRAILER CHARGE GROUP}) - 6
ELSE IF {@TRAILER CHARGE GROUP} &lt;&gt; 'INTCNEWNC' THEN Count ({TRAILER_CUSTOMER_ZONE.TRAILER_ID}, {@TRAILER CHARGE GROUP} ) 
</code></pre>

<p>I am using Crystal Reports XI on a DB2 server.</p>

<p>Thanks in advance! </p>

<p>edit: INTCNEWNC is the charge group, whereas ASHLADVNC and MARSBIVA are the drop customers. You can clearly see the individual counts for Drop customers are fine but the count for charge groups is where I am struggling. </p>