Lotus Notes FAQ Visit Our Sponsor!

How do you sum number fields which have not been edited and initialized?

There are a few approaches to this problem. All of them include testing the value of each number field before summing the total:

mtotal := @If(field1 = ""; 0; field1) + @If(field2 = ""; 0; field2) +...;

Or in the input translation of each field you can do this:


Applies to Notes Versions: 3 4 4.5 4.6 5
Last Modified: July 14, 1997