Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ALL
Functions and Expressions Reference Guide
65
ALL
The ALL function evaluates a series of conditions and returns TRUE if they all
evaluate to TRUE; otherwise returns FALSE
Syntax
ALL (series-condition-expression)
Meaning
ALL (conditions_to_evaluate)
Returns
This function returns TRUE or FALSE.
Evaluates to TRUE if all members of the input argument evaluate to TRUE.
Evaluates to FALSE if any member of the input argument is FALSE.
Examples
PO (s)=IF (ALL( PO#:Line:Order = PO#:Line:Order[1]), Order,
NONE)
If each and every PO# matches the PO# of the first Order, ALL evaluates to
TRUE. Otherwise,
ALL evaluates to FALSE.
Uses
Use
ALL when you want to test whether all conditions of a series are true.
Related Functions
NOT, OR