Summing Problem

[Patrick Graham]

Hello,

I have a report that is laid out as such:

Sales Rep Name (Head)
---Advisor Company (Head)
------Advisor Name (Head)
----------Client Name (Head) Closed Amount
Sales Rep Name (Footer) Sum(Closed Amount)

The idea is that for each Sales Rep the Closed Amount
belonging to them would be totaled.

Problem I'm having is that the closed amount is acting
like a running total.

So the report ends up looking like this
Sales Rep 1's total closed ammount is $100 <--($100)
Sales Rep 2's total closed ammount is $150 <--($50)
Sales Rep 3's total closed ammount is $250 <---($100)

when the totals should be 100, 50 , 100

Help please as this is for work and seems like the fix
shoudl be obvious. Thanks

 

[Marshall Barton]

I have a report that is laid out as such:

Sales Rep Name (Head)
---Advisor Company (Head)
------Advisor Name (Head)
----------Client Name (Head) Closed Amount
Sales Rep Name (Footer) Sum(Closed Amount)

The idea is that for each Sales Rep the Closed Amount
belonging to them would be totaled.

Problem I'm having is that the closed amount is acting
like a running total.

So the report ends up looking like this
Sales Rep 1's total closed ammount is $100 <--($100)
Sales Rep 2's total closed ammount is $150 <--($50)
Sales Rep 3's total closed ammount is $250 <---($100)

when the totals should be 100, 50 , 100

From here, it looks like your total text box has its
RunningSum property set to something other than No.