Link to home
Start Free TrialLog in
Avatar of KavyaVS
KavyaVS

asked on

Sum of the group based on condition

I need to calculate the sum of the group1 in crystal report.The report is like this.
Group1 is TypeID
Group2 is MemberID
Group2 has Details section.It has fields like Name,TransactionDate and Balance.

It looks as follows:
Group1Header TypeID
Group2Header MemberID
Details Name  Transactiondate   Balance    
           123        02/13/2011          $100  
           123        02/13/2011          $100
Group2Header MemberID
Details Name       Transactiondate   Balance    
                 345        02/13/2011        $200  
                 345        02/13/2011        $200
                 345        02/13/2011        $200
Group2Header MemberID
Details Name       Transactiondate   Balance    
                   ----         ---------                 ----
Group1Footer Sum for Group1 Sum(Balance)= $300

The sum has to consider only one record in each details section.Because the balance is repeating for the same member.
So, I need to consider it only once.
How to do this. Please let me know.

Thanks
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial