Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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