AnsweredAssumed Answered

IsEmpty Function

Question asked by rtolliver on Apr 28, 2015
Latest reply on Apr 30, 2015 by philmodjunk

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

 

 

 

 

Outcomes