Formula reset in Running Total for Crystal Reports

metalteck
metalteck used Ask the Experts™
on
I currently have a running total that is summing all accounts and changing based on location.
Is there a way I can use the formula editor in the reset portion of the running total to exclude a certain account?  I can't exclude the location from the report all together because I need to use it for another column.  
I'm currently using Crystal 2008

What it currently is:          
      Location 1
Ex. Account 1  1000
     Account 2 15000
     Account 3 25000
     Account 4 1000
   Running Total Amount: 42000

Expected:
      Location 1
Ex. Account 1  1000
     Account 2 15000
     Account 3 25000
     Running Total Amount: 41000
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
It would not be in the reset unless you want it reset to 0 then

I think you want to use the EVALUATE option of USE A FORMULA
{AccountNumber} <> "Account 4"

If you want to reset then use
{AccountNumber} = "Account 4"

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial