Results 1 to 2 of 2

Thread: How NOT to sum a suppressed field.

  1. Mar 6th, 2006, 05:29 PM #1
    jthill
    jthill is offline

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    1

    How NOT to sum a suppressed field.

    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)?
    Last edited by jthill; Mar 6th, 2006 at 05:34 PM.
    Reply With Quote Reply With Quote
  2. Mar 6th, 2006, 05:55 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: How NOT to sum a suppressed field.

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width