Functions
REDUCE
Reduces an array to a single value using a LAMBDA
Try it
When to use it
When should I use REDUCE?
Use REDUCE to fold an array down to a single accumulated value using a LAMBDA, useful for custom summations, products, or running aggregations.
Used in
Syntax
REDUCE(initial_value, array, lambda)