Skip to Content
author's profile photo
Former Member

summation of a formula field

I have written a formula as,



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.



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


    Numbervar X := 0;


    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.


    Numbervar X := x + ; ( or formula)


    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.)


    Numbervar X;


    Add comment
    10|10000 characters needed characters exceeded