Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Totals: adding zero values

Status
Not open for further replies.
May 7, 2001
6
AU
I have a running total which seems to work fine except when a value in the list is equal to zero, the running total adds a number (in my case 0.79) to the total instead of zero. I dont know why this is happening. I have the running total running alongside the values which are being cumulatively added. This makes no sense.

I am using CR6.

300 400
200 600
101 701
0 701.79 <<<< cant understand this.
300 1001.79

Does anyone have a clue as to why this would happen?

Thanks!
 
please excuse my stupidity, figured this one out, was an error in my formula. No ghosts in the machine this time :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top