Printable View
In the detail of my report, I have suppressed certain fields based on certain criteria. I am trying to do a running total of a field, but it sums the suppressed fields as well. How do you create a running total without summing the suppressed fields (if possible)?
On the Edit Running Total Field screen there is a section called Evaluate. This section contains several options that specify when the value of the field should be included in the Running Total value.
In your case, select the Use a Formula option and use the same formula that you used to suppress the field, except return the opposite.
For example,
Suppress Field formula
{[Order Details].ProductID} = 11
Running Total Formula
{[Order Details].ProductID} <> 11