DIVIDE

Divides one number by another and returns an alternate value when the operation results in an error, ensuring reliable calculations.

The DIVIDE function returns the result of dividing one number by another. It takes a numerator and a denominator as inputs and performs the division operation. This function is commonly used in calculations involving ratios, percentages, averages, and other mathematical operations where one value needs to be divided by another.

Syntax

DIVIDE (Numerator, Denominator, Alternate)

Arguments

Numerator, Denominator - The values to be divided (Required).

Alternate - An alternate value is returned when the division results in an error. In case the denominator is null and there is no alternate, it returns the #VALUE! error. This argument is optional.

Example

DIVIDE (COLUMN1, COLUMN2, 0)

In the example below, the DIVIDE measure is created using the DIVIDE function, which returns the result of dividing MEASURE 1 (numerator) by MEASURE 2 (denominator).

Applying DIVIDE function