Alpha Video Training
Results 1 to 3 of 3

Thread: Summary and Average

  1. #1
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Summary and Average

    1-Create a simple table with 5 fields:
    Field1: Country
    field2: State
    field3: City
    field4: quantity
    field5: price

    2-Summarize that table on the first 3 fields to get the sum of field4 and average of field5

    The sum of field4 will return the correct amount, the average of field5 will not.

    Test your results against Excel or just do it manually. The average is incorrect.

    I don't think it's the summarize operation per se, but it seems that it has to do with calculating the average. Evidently alpha divideds the total price by the number of records not by the sum of field4 and hence the error.

    My tests were done in v8 and I wish someone will check in v8 as well as v9.

    Incidentally, same error appears if you do a report with averages.
    Last edited by G Gabriel; 11-28-2008 at 11:16 AM.

  2. #2
    VAR John Oesterle's Avatar
    Real Name
    John Oesterle
    Join Date
    Apr 2000
    Location
    Midwest
    Posts
    236

    Default Re: Summary and Average

    Gabe -

    I renamed your operation/summary dbf to test_sum09 and ran the operation in the current version of v9. The averages were the same.

    I did not construct a new test from scratch.

    - John O

  3. #3
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Summary and Average

    Thanks John. I put this thread here by error. See discussion in the other board section.

Similar Threads

  1. Count and Average Q
    By seidel1 in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-03-2004, 08:34 AM
  2. Computing Average in Rpt Summary
    By Eric Johnson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-21-2003, 05:26 PM
  3. Average
    By edward.mattison@scbhn.org in forum Alpha Five Version 5
    Replies: 12
    Last Post: 12-10-2002, 11:56 PM
  4. Average Function.
    By Sharon Bracken in forum Alpha Five Version 5
    Replies: 6
    Last Post: 08-08-2002, 11:03 AM
  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
  •