Alpha Video Training
Results 1 to 3 of 3

Thread: Conditional Counts

  1. #1
    Jim VanGelder

    Default Conditional Counts

    There must be a simple way to count occurances of various values within a single field for a report but I can't figure it out.
    The field is "status" --- Values are "TD", "WD", "AC", etc.
    I need to determine how many records are in each "status" to be printed in the report footer.

    Also, where can I find syntax definition/examples for the various "functions" ???

  2. #2
    Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    The Dreaded Chair

    Default RE: Conditional Counts

    For each value you want to count, make a calculated field in your report design, like this:

    IF(STATUS = "TD", 1, 0)

    Then, use the drag-drop list to drag that calc field onto your report. When the genie pops up, select the "TOTAL" function.

    - Steve

  3. #3
    nick marodis

    Default RE: Conditional Counts

    You can also create a group based on the status field and group records
    together with the same value and then count the number in the group.

    Just a suggestion.

    Have Fun

Similar Threads

  1. Conditional
    By dcorcoran in forum Alpha Five Version 6
    Replies: 4
    Last Post: 12-02-2006, 12:49 PM
  2. Conditional Help
    By Bo Vandenberg in forum Alpha Five Version 5
    Replies: 1
    Last Post: 09-19-2003, 03:13 AM
  3. Percent of Counts in Reports
    By Chris.Tanti in forum Alpha Five Version 4
    Replies: 14
    Last Post: 06-15-2000, 11:23 AM
  4. un-conditional
    By Sandy Garrett in forum Alpha Five Version 4
    Replies: 3
    Last Post: 05-10-2000, 05:09 AM
  5. Printing group counts in order
    By Pete Cantele in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-13-2000, 09:00 AM


Posting Permissions

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