How to calculate sum of Balance only for 2 groups out of 4 groups

KavyaVS
KavyaVS used Ask the Experts™
on
I have a crystal report  which I grouped  based on ID.There are 4 types of ID's.

GH1    ID=100    
                                Balance

GF1:                        ID=100        Sum Of Balance

GH1:  ID= 101    
                          Balance  

GF1:                      ID =101       Sum of Balance

GH1:  ID= 102                  
                             Balance  

GF1:                      ID =102       Sum of Balance

GH1:  ID= 102                
                             Balance  

GF1:                      ID =102       Sum of Balance

GH1:  ID= 103    
                              Balance  

GF1:                      ID =102       Sum of Balance


I want to calculate the sum of balance for two  ID's(100,101).
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
An easy way is to create a formula

If {IdField} IN [100,101] then
   {AmountField}
Else
   0

You can then summarize it as you need to.

You could also use a running total that evaluated when  {IdField} IN [100,101]

mlmcc
Priya PerumpilavilSoftware Engineer
Commented:
or you can create the runnining total,use the formula idfield in   [100,101]

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial