Results 1 to 2 of 2

Thread: Count, sum question?

  1. May 26th, 2004, 08:41 AM #1
    janis
    janis is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Location
    top of the mountain
    Posts
    234

    Question Count, sum question?

    I think this is easy but ...
    Namely, I want to count recodrs in crystal report based on one field e.g. if table.field7=1 then count else do not count. Samething I want to do with sum function ( e.g sum only records where table.field5=0)
    How to do that?

    regrad j
    Reply With Quote Reply With Quote
  2. May 26th, 2004, 10:06 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    There are a couple of ways.

    The easiest is to use "Running Totals", which have a variety of options for counting, summing etc. - including using formulas.

    Create a formula, you can count sum anything you want using formulas.
    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