LCM function

Returns the least common multiple of each number in two columns.

Note: The columns must have the same data type.

Namespace

  • arithmetic

Input

Numeric values

Output

Numeric values

Syntax

set-column :column arithmetic:lcm(column1, column2)

Example

Returns the least common multiple of each number in the sales_q1 and sales_q2 columns:

set-column :sales_h1 arithmetic:lcm(sales_q1, sales_q2)

 

Created in 2020 by Google Inc.