Skip to Content
author's profile photo Former Member
Former Member

Calculating the sum based on condition

Hello Everybody,

I am currently working on a report, where i have to calculate sum on transaction amount for all account numbers. Below is the example of data.

masteraccount accountno transaction amount

1001 001 50000000

1001 002 50000000

1001 003 50000000

1002 004 98765

1002 005 98765

here i have to calculate the sum of transaction amount based on distinct master account.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2010 at 01:50 PM

    create a group for master account

    use manual running totals.


    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.