Alpha Video Training
Results 1 to 3 of 3

Thread: Child Calculations

  1. #1
    Member
    Real Name
    Rudy Pataky
    Join Date
    Apr 2008
    Location
    Toms River, NJ
    Posts
    171

    Default Child Calculations

    Can someone help me out with a couple of calculations? I'm having trouble getting them to work. I'm trying to total up amounts within a child table set. It totals the entire child table, not the linked parent/child details.

    I just started this db and need the formulas for Transaction Total on det_form. It's totaling the entire table, It should be only on the Account selected.

    Also in report (det_rpt_1), the group account nfooter and report footer are not working.

    Thanks,

    Password to Show and Hide Control Panels is 76rudy5
    Last edited by Rudy16; 10-31-2009 at 02:41 AM. Reason: Changed db app

  2. #2
    Member
    Real Name
    Rudy Pataky
    Join Date
    Apr 2008
    Location
    Toms River, NJ
    Posts
    171

    Default Re: Child Calculations

    Fixed Form Calculation.

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

    Default Re: Child Calculations

    It's totaling the entire table
    It?

    You should take a look at the documentation for total() paying attention to the GRP – >Sub_Group
    which can be the name of a table in the current set.

    You might try something like

    Code:
    total(childtablename->Transaction Total, GRP–>parenttablename, GRP–>childtablename )

    Tablesum() and dbsum() are also useful.

    You seem to have included the password for a database which didn't get attached.
    There can be only one.

Similar Threads

  1. Replies: 13
    Last Post: 03-14-2007, 06:59 PM
  2. XY Calculations
    By Paul Main in forum Alpha Five Version 6
    Replies: 18
    Last Post: 02-14-2006, 12:56 PM
  3. Calculations
    By Robert Nielson in forum Code Archive
    Replies: 1
    Last Post: 09-09-2004, 06:56 AM
  4. CALCULATIONS
    By samuelboles in forum Alpha Five Version 4
    Replies: 7
    Last Post: 03-31-2001, 08:58 PM

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
  •