Alpha Video Training
Results 1 to 3 of 3

Thread: Computing Average in Rpt Summary

  1. #1
    Member
    Real Name
    Eric Johnson
    Join Date
    Apr 2000
    Posts
    171

    Default Computing Average in Rpt Summary

    I've been suspicious and just now created a sample that proves it. The "average" option used when a field is placed on a report includes null values in the computation. Should it not ignore a record in which the field being averages is null?

    Thanks.

    Eric Johnson

  2. #2
    Member
    Real Name
    Duncan Greenshields
    Join Date
    May 2000
    Location
    Toronto, ON
    Posts
    216

    Default RE: Computing Average in Rpt Summary

    Eric;
    Unfortunately, in A5 to get your "true" average (i.e. excluding "0" or null values) you will have to create a calculated field, and then take its average [e.g. if(myfield>0,mycalcfield,0)].

    Duncan

  3. #3
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Computing Average in Rpt Summary

    Duncan,

    I've done it a different way.

    Just drag and drop a new calc field into the details band of the report. Use an expression like this:

    If(your_field_value > 0, 1, 0)

    this returns a 1 for each record that actually has a value greater than zero, and a zero for each that does not.

    Now create a new calc summary field and total the values in the first calc field. You'll get a number that matches the actual number of records with values greater than zero. This becomes the denominator in a new average calculation (instead of the actual number of records that are being summed to create the numberator).

    It's easier to do than to describe.

    -- tom

Similar Threads

  1. Monthly average
    By edward.mattison@scbhn.org in forum Alpha Five Version 6
    Replies: 7
    Last Post: 08-19-2005, 12:52 PM
  2. With a view to portable computing
    By Bob Whitaker in forum Archived Wishlist
    Replies: 0
    Last Post: 04-13-2005, 05:13 AM
  3. Count and Average Q
    By seidel1 in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-03-2004, 08:34 AM
  4. Average
    By edward.mattison@scbhn.org in forum Alpha Five Version 5
    Replies: 12
    Last Post: 12-10-2002, 11:56 PM
  5. summary functions i.e. stddev, variance, average
    By videomuger in forum Alpha Five Version 4
    Replies: 5
    Last Post: 01-12-2001, 01:34 AM

Bookmarks

Posting Permissions

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