Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    5

    Unanswered: Count only needed values

    I want to create a formula in crystal report 9 that counts only the fields that has a value equal to "A" ,is it possible to do so?

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    You'll need to create a calculated field in the detail section and add them together at the end.

    Something like "If myField = "A" then 1 else 0"

    Sum this filed up and you'll have a count of all the records where the field your interested in is "A".

  3. #3
    Join Date
    Jan 2003
    Location
    British Columbia
    Posts
    44
    or use the built in functionality called Running Totals.

Posting Permissions

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