...
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"
)
) |