Alpha Video Training
Results 1 to 3 of 3

Thread: TOTAL function

  1. #1
    David Patterson

    Default TOTAL function

    I have several formulas within reports that utilize the "TOTAL" FUNCTION. When I converted the files from Alpha Version 1 to Alpha Version 4.5 the formulas for this particular report did not convert over. Not a big deal, I typed them back in but now the formula with the TOTAL function apparently must be written a different way. An example in A5 Version 1: total(field1=.t.,grp->group1) In A5 Version 4, the "grp->" for some reason is being kicked back with an error. I don't know the syntax for the newer version. Any help would be appreciated. Thank you.

  2. #2
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000

    Default RE: TOTAL function

    I report design mode, place the field in the area of the report desired. When you let up on the mouse key, the genie will open and ask whether you want the value, total, etc. Select total and the genie will determine the expression needed.

  3. #3
    David Patterson

    Default RE: TOTAL function

    SOLVED !!!!

    In group properties there is a group header, the name of the group. No spaces or unusual characters like the # sign can be used. Instead of using a field name of FF_ID#, use only the FFID and all works fine, no problems calculated fields are converted.

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. Total () Function
    By Martin Konieczny in forum Alpha Five Version 5
    Replies: 3
    Last Post: 07-28-2003, 08:06 AM
  5. odd total function required
    By eeetee in forum Alpha Five Version 4
    Replies: 4
    Last Post: 11-21-2002, 08:03 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