REDUCE (PQL - xl)

This function reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

REDUCE(OPTIONAL initial value, array, function)

Function Arguments

Name

Description

Type

Optional

initial value

Sets the starting value for the accumulator

StringOrNumber

Y

array

An array to be reduced

StringOrNumber

function

A LAMBDA that is called to reduce the array

String

Comments

This function is the same as the Microsoft Excel 'REDUCE' function - using the same inputs, logic and outputs.