Skip to Content
0
Former Member
Sep 07, 2010 at 01:01 PM

Calculating the sum based on condition

40 Views

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.

Thansk

Ram