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