Returns its input, or falls back to a default value if the input is null.
Function
isnull(input, null-result)
Arguments
| Argument | Data Type |
| input | any |
|---|---|
| null-result | any |
| result | any |
Comments
If input is null, then the null-result is returned, otherwise the input is returned.
Examples
The following calculation will follow a relationship named 'Person' and show the person's name, or the text 'No person' if there was no related person.
isnull([Person], 'No person')