Domino Code Fragment

Code Name*
Sum number fields which have not been edited and
initialized
Date*
04/28/2024
Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.18.116.62.45
Description*
Sum number fields which have not been edited and
initialized.
Type*
Formula
Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
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)