Description
The COALESCE function finds the first non-blank value in one or more arguments.
Usage
COALESCE(val1, val2, ...)
Result
The first non-empty value found, by order of input arguments (val1 will be checked first, then val2, etc.)
Example
We will be using the COALESCE function to find the first defined row value from a set of three columns.
Arguments
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")
Formula
COALESCE(val1,val2,val3)
Results
