### Title

IsEmpty Function

### Post

I'm looking for help in identifying the correct FM function or procedure that is the equivalent to the Access 2010 (NZ Function) Example; the NZ(FieldName.value,0) function evaluates FieldName for null and if true returns 0.

I have FM four fields that are part of a sum calculation and I'd like to test each field and provide a 0 for the calculation if the tested field IsNull.

I'm not quite a newbie, but I've been away from FM for a while and any help is appreciated.

Thanks

IsEmpty will return 1 if the field is empty and 0 if the field is not empty.