You could use e.g. if(Count(Field)=0,'NA',Sum(Field)). If a field's count is 0 that means there are no non-null values (a field can have sum=0 but still have valid values, e.g. -1 and 1). Note that doing this may cause formatting issues since you're placing a textual value into what would otherwise be a numeric column.
