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:

@If(@IsNumber(FIELDNAME); FIELDNAME; 0)


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