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

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® 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
Software Engineer
Commented:
or you can create the runnining total,use the formula idfield in   [100,101]

Do more with