Good morning -
Yes you are correct - if there are null values Tableau will return a null for the aggregation - try wrapint the measure in zn - like sum(zn(measure))
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.
1 of 1 people found this helpful
You can amend your null values with ISNULL function. Just place zero as the condtion of null.
Trust this helps.