Trying to create a measure with a dimension using if / then statement.
Goal - IF [dimension name] = 0 or Null THEN [measure name missing]
What is the proper IF / THEN calculated metric statement for this? Do I need to create a group name or parameter so the null/0 entries are categorized correctly?
Try something like the following. You'll notice i wrapped the zero in single quotes since I'm comparing a dimension (category).
Thank you!! It worked.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...