Is there a way to total a sum field? This is what I have.

if {@Serving Out Of County-1} = true then 1 else 0

It gives me the value of 1.

 

Then I create a new formula.

if sum ({@Serving Out Of County-2}) =[1,3] then 1 else 0

 

I put this then in the Group Footer.

 

 

Now I want to sum all the values of 1 from the new Formula Sum in the Group Footer and put the total of all in the report footer.

 

This this possible?

 

 

If the sum would be odd numbers. I just did not put all odd numbers in, just testing 1 and 3 to see if it worked and it did. If the number is odd then I then would change it to 1 and get that sum of the change.

How would that select the odd number and then total?

I want to total mark field, but excepting a record and put summary in Group Header like this:

Name                                     |                   mark       |
-----------------------------------------------------------------
Room1(group header)           |                       8          |   (5+4+7)-4
-----------------------------------------------------------------
duy                                        |                       5         |
anh                                        |                       4         |
tran                                       |                       7         |
-----------------------------------------------------------------
Room2(group header)           |                     15         |
-----------------------------------------------------------------
a                                            |                      7
b                                            |                      3
c                                            |                       8

Please help me,Please use fomular C#