I am attempting to accumulate a running total based on a status of a project being "Open" or "Closed".

 

Using the a Running Total Field I am summarizing the projects RemainingHours.  In the Evaluate area I have selected to use a formula.

 

The formula:

 

If {status} = "Closed" then

  {RemainingHours} = 0

else

  {RemainingHours} = {RemainingHours}

 

The {RemainingHours} = {RemainingHours} seems a little odd to me (I think I hear some giggles), but it works. When it is not working, I get the Closed project's remaining hours.   Anyone have a better suggestion?

 

Thanks,

Rich

 

I have found the problem.  I have two files, a project file and a journal file.  I am listing the project once, while there may be several journals.  I did not realize that the project remaining hours would attempt to sum even though it was not getting listed for every journal.  Once the sum was changed to sum on change of project only, it all added up.

 

Thanks again,

R