If you need to put the result in a calculated field, I think your will need to use the + method.
It sounds like there are nulls in your data.
If your columns are numerical, you can use
If your columns are text, you can use:
Please see workbook v10.3 attached in the Forum Thread.
281979null.twbx 11.1 KB
Good morning -
not certain I understand your issue
the way you describe "Combined fields" sounds like you are concatenating 2 dimensions which are strings (text) and some of the data are nulls
you want a concatenated text as the result and want to eliminate the 0 in col2 from nulls then [col1]+ifnull([col2],null) should work
if the data are numeric and you expect a numeric result then you would use sum(zn(col1)) + sum(zn(col2)) for example
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.