Skip to main content

Logical Functions (Locked)

Row-level logical operators, conditionals, and user-context predicates. Signatures cite help.tableau.com.

Conditionals​

FunctionSignatureReturnNotes
IF ... THEN ... [ELSEIF] ... ELSE ... ENDIF condition THEN result [ELSEIF ...] ELSE fallback ENDAnyStandard branching.
CASE ... WHEN ... THEN ... [ELSE] ... ENDCASE expression WHEN value THEN result [ELSE fallback] ENDAnyEquality-only pattern; prefer IF for range checks.
IIFIIF(condition, true_value, false_value, [null_value])AnyShort-form. Optional 4th arg for NULL branch.
IFNULLIFNULL(expression, fallback)AnyFallback if expression is NULL.
ISNULLISNULL(expression)BooleanReturns TRUE if NULL.
ZNZN(expression)NumberZero if NULL; also in number.md.

Booleans​

FunctionSignatureReturn
ANDcondition1 AND condition2Boolean
ORcondition1 OR condition2Boolean
NOTNOT conditionBoolean
INexpression IN (value1, value2, ...)Boolean

User Context (2023.3+ where noted)​

FunctionSignatureReturnNotes
USERNAMEUSERNAME()StringCurrent username.
USEREMAILUSEREMAIL()String2023.3+. Current user's email.
USERDOMAINUSERDOMAIN()StringDomain portion of username.
ISUSERADMINISUSERADMIN()BooleanTRUE if user is site admin.
ISFULLNAMEISFULLNAME(string)BooleanTRUE if current user matches.
ISUSERNAMEISUSERNAME(string)BooleanTRUE if current user matches.
ISMEMBEROFISMEMBEROF(group_name)BooleanTRUE if user is in group.

Common Patterns​

  • Boolean flag: [Sales] > 500 returns Boolean directly, no IF needed.
  • NULL-safe default: IFNULL([Field], 0).
  • Range bucketing: IF [Sales] < 100 THEN 'Low' ELSEIF [Sales] < 500 THEN 'Med' ELSE 'High' END.
  • Row-level security proxy: IF [Region] = USERDOMAIN() OR ISUSERADMIN() THEN [Sales] END.

R-BOOL-01 Discipline​

Boolean calcs return TRUE/FALSE/NULL. Never 1/0/-1. Downstream logic tests as:

  • Correct: IF [BoolCalc] THEN ... END
  • Wrong: IF [BoolCalc] = 1 THEN ... END

Common Anti-Patterns​

  • IF [Field] = TRUE THEN 'Y' ELSE 'N' END when Boolean directly works.
  • IIF nested >2 levels; use IF for readability.
  • ISNULL([Field]) = TRUE when ISNULL([Field]) alone works.
  • CASE for range comparisons; use IF/ELSEIF instead.

Version Notes​

  • USEREMAIL requires Desktop 2023.3+.
  • Everything else available Desktop 2020.1+.