Alpha Video Training
Results 1 to 4 of 4

Thread: Total () Function

  1. #1
    Martin Konieczny

    Default Total () Function

    Why does the expression: TOTAL(Amount,GRP->Name)yield an "incomplete or invalid expression" comment when plugged into the expression builder for a calculated field? It should yield the total "Amount" spent for the given "Name". This exact same expression works as a group footer total in a report using the same table.

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000

    Default RE: Total () Function

    Search for related threads discussing this function. You will find that it is problematic when used in a form, having apparently been designed to work in reports. Most recommend substituting tablesum() or dbsum() if needed in a form display calc field.

    -- tom

  3. #3
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    S.E. Michigan

    Default RE: Total () Function

    Also, other possible causes would depend on how and where this is being used.

    If it is used in a calculated field in a table, the "GRP->Record" would, I believe, be meaningless.

    If it is used in a calculated field on a form, the form would have to be based on a set and the set would need to contain a table called "Record".

    The GRP in a report refers to a group defined in the report. In a form, there are no "group" sections so the GRP refers to a table.

  4. #4
    Martin Konieczny

    Default RE: Total () Function

    Thanks, your comments have gotten me on the right track.

Similar Threads

  1. Report - Total Function
    By Jonathan Short in forum Alpha Five Version 6
    Replies: 1
    Last Post: 02-16-2005, 01:47 PM
  2. Running total function
    By Dr Alok Modi MD in forum Alpha Five Version 5
    Replies: 7
    Last Post: 05-01-2004, 01:04 PM
  3. Total function using data from set
    By DougMcLean in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-22-2004, 08:12 AM
  4. odd total function required
    By eeetee in forum Alpha Five Version 4
    Replies: 4
    Last Post: 11-21-2002, 08:03 AM
  5. TOTAL function
    By David Patterson in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-20-2001, 09:09 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