Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate new field without blanks or NULLs

Hey community,

I want to create a new field with the expression if([Field1]+[Field 2]<'2014','YES','NO') as [New Field]

However, I want the expression to also ignore where there are nulls or 0s in either Field 1 or Field 2. How do I do this?

1 Reply
Not applicable
Author

just say alt(Field 1,0)+alt([Field 2],0)