Summing Problem

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

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
 
Patrick said:
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
Click to expand...


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