Calculating with negative numbers

[ema]

I don't know if this is possible, but maybe there is a way to do this. I have form that is calculating points. Some are whole numbers and some are negative numbers. At the end I have a summed total of the points. the problem is that someone may have -1 points at the beginning of their list and whole number points toward the end. For example:
-1
-1
1
2
Total: 1

I want the total to be 3 and not factor in the -1(s) at the beginning.
I hope some one can understand this and know if theres a way to do this. Thanks in advance!!!

 

[Abby N]

What you need to do is create a field that sets negative values to zero, then sum that field. Create an unbound control. I'll call it [PosPoints] and set its visible property to 'No'. Set it's source to:

=IIF([YourPointsField]<0,0,[YourPointsField])

Now, instead of having the summation field total [Points], have it total [PosPoints]. Good Luck.

~Abby