Skip to Content
author's profile photo
Former Member

summation of a formula field

I have written a formula as,

whilprintingrecords;

{table.duration)

Now in report footer i need the sum(formula).

Can anyone please help me out?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 01:22 PM

    i gather this goes with your previous post.

    in order to use the manual running totals you need to create 3 formulas

    you also need to have groups created, if you want to total on a group. if you want an overall report total the reset goes in the page header and the display goes in page footer.

    MANUAL RUNNING TOTALS

    RESET

    The reset formula is placed in a group header report header to reset the summary to zero for each unique record it groups by.

    whileprintingrecords;

    Numbervar X := 0;

    CALCULATION

    The calculation is placed adjacent to the field or formula that is being calculated.

    (if there are duplicate values; create a group on the field that is being calculated on. If there are not duplicate records, the detail section is used.

    whileprintingrecords;

    Numbervar X := x + ; ( or formula)

    DISPLAY

    The display is the sum of what is being calculated. This is placed in a group, page or report footer. (generally placed in the group footer of the group header where the reset is placed.)

    whileprintingrecords;

    Numbervar X;

    X

    Add comment
    10|10000 characters needed characters exceeded