I have a table where the default value of many cells is an asterisk (*). In my set expression I'm trying to select on these values, but the resulting sum is totaling the entire selection - probably because the * is actually an operator of some description. I've attempted to place it inside quotes, eg
both these result in the same end result - the entire set is summed, not just the columns with cells = *.
Definitely something to remember for the future - I have about 57 columns in my datasource, the above formulas are good workarounds but as the expressions get larger (I have a behemoth to write shortly), they will, i suspect, start to become somewhat hard to read.