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

Why is this expressing to null?

I can't seem to figure out why this is expressing to null (-) instead of 0:

=IF(LEN(TRIM(fieldname)) = 0, 0 , Len(fieldname))

null check error.jpg

Labels (1)
1 Reply
Evan0211
Creator II
Creator II
Author

This also expresses to (-) instead of string null.

=if(isnull(fieldname), 'null', fieldname)