Alpha Video Training
Results 1 to 3 of 3

Thread: How do you add a calc field to display the average of a numeric field within a group footer

  1. #1
    Member
    Real Name
    David Johnson
    Join Date
    Jan 2014
    Posts
    1

    Default How do you add a calc field to display the average of a numeric field within a group footer

    Hi:

    I am trying to simply calculate the average of a numeric field within a group footer in a group break of a report. I have tried to drag the field onto the group footer area and then select the average option and it doesn't create the field as a calc field but it creates a variable field.

    Dwjgoblue

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: How do you add a calc field to display the average of a numeric field within a group footer

    I'm unfamiliar with "variable fields"

    Suggest you restart the computer and try again. Should be a simple task accomplished as described.
    There can be only one.

  3. #3
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,212

    Default Re: How do you add a calc field to display the average of a numeric field within a group footer

    Hi David,
    Welcome to Alpha. Steps I believe you would do..
    1. Place report in design mode
    2. Select <New Calculated Field> from DragDrop list and drag to report footer
    3. Name the calculated field and open the expression builder (the XY button). Highlight Field Name .... F2, press Insert button and select the field you want to average
    4. Select the "average of the field radio button in the Define Calculated Field/Summary dialog.

    This may be what you are doing, and if it is not working, do what Stan suggested and try again.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

Similar Threads

  1. Report Calc field coming back as Character instead of Numeric
    By jeand in forum Alpha Five Version 11 - Desktop Applications
    Replies: 15
    Last Post: 07-08-2013, 08:44 PM
  2. Problem with calculated field in Group footer
    By dsmothers in forum Alpha Five Version 9 - Desktop Applications
    Replies: 1
    Last Post: 11-14-2012, 06:22 PM
  3. Need 2 totals for one field to go on a group footer
    By OctoBit in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 02-03-2010, 10:40 PM
  4. Display of numeric field is unrecognizable
    By Randy Hyland in forum Alpha Five Version 5
    Replies: 6
    Last Post: 10-16-2003, 09:35 AM
  5. Display Calc Field Name ??
    By Gary Phillips in forum Alpha Five Version 5
    Replies: 9
    Last Post: 06-23-2003, 11:07 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
  •