COALESCE

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

Next item
MULTIPLY (*)