I have a report that contains two different status ID values. I had to do some totaling based on separate status ID by creating a simple formula of: 

If (table.statusID) = 1
then table.fieldvalue)
else 0

I did this and got an initial subtotal fine.

I also did this another field for statusid - 3 as I had to separate them, but include them both on same report.

Now I am trying to do a summary of that subtotal and I am getting some hugely insane number not even close to the correct values.
I have the report
groping by a team, then date range, and then individual. I created the first subtotal based on date range by individual, and now trying to do a team total by month.

Hopefully that make sense.

Flanman

No. This is a different report. The values and status ID on this report are actually in the same table. That is why I am at a loss.

Flanman

I am using more than one table, but the field I am trying to summarize is of course all on one table. I checked my formula and looks like:
Sum ({@ProceduresGoal},{DriveMaster.FromDateTime} , "Monthly"). but I am still getting an extremely high number. I also checked my db expert for joins, et and look fine from what I can see.

What I have figured out is I am doing a summary by monthly of a rep.  I am adding several columns and that is all fine. However, this one field Is a Monthly Goal. The Goal is a static number until I try to summarize it for more than one rep. When I do that summary the Goal is summarizing for each entry and that is why I am getting the large number. I will illustrate below

Employee1
Date                 field1    Field2    Goal
1/2/09                  5            5      
1/5/09                 10          12     
1/9/09                   6           9        
MonthlySub         21          26       100

Employee2
Date                 field1    Field2    Goal
1/2/09                  8           14   
1/5/09                 12          7     
1/9/09                 10          12       
MonthlySub         30          33      150

Team Sub           51          59       750 (here is the issue) total should be 250

In the report I am surpressing the daily details, and only showing the Monthly and then team subtotals. The original goal value is coming from a joined and matches fine for the employee subtotal as I do not have that field in the details section, but when subtotaling for the team it is adding the goal for every day. Hopefully that all makes sense.

Flanman

Once Again you are a great help and a genius. I was working on this all week. Thanks so much for the help and have a happy holiday.