Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

Some of your data may contain missing values.  If so, there is an isNull() function that can be used to change the outcome of the expression based on the presence of a missing value.  The following example generates a text results based on the Age field but does not handle missing values:

Code Block
if (
    [Age] >= 50,
    "Over the Hill",
    "Under the Hill"
)

...

Code Block
if (
    isNull([Age]),
    "Don't Know",
    if (
        [Age] >= 50,
        "Over the Hill",
        "Under the Hill"
    )
)