Strings in expression / adding columns

[zagzebski]

Is there a simple way to replace a "0"  amount with a string in an expression.

Once the string is in place I assume there is no way to add columns using column names because it won't effectively add columns that have strings in them?

Zag

[sunny_talwar]

I think you should be able to use RangeSum() which would still sum if one or more columns have numeric value

RangeSum(Column(1), Column(2), Column(3))

If for example, a particular row have

10, NA, 10, the above expression will give you 20