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 = *.
Any ideas how i can 'escape' * to mean "*"?
Solved! Go to Solution.
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.
While loading you can change the script as
Replace(Field2,'*','|') as Field2
So you will have same number of columns (57). I just give you an idea. If you have one or two, it would be helpful.