Error Messages/41094

Error message examples

 A position of 0 is specified in the «map» parameter to Aggregate at @IndexI = 1, which is out of range.
 It must be between 1 and 6.

Cause

When the «positional» parameter to the function Aggregate is specified to the true, the «map» parameter to the function must be a numerical and positional index of the «targetIndex» parameter. At least one cell in the passed in «map» parameter specifies a position outside the range in «targetIndex».

Please note that the first positional index value starts from 1 and not 0.

See Positional Maps to learn more about passing positional maps compared to value maps to the Aggregate function.

Remedies

Correct the «map» parameter so that all the cells hold a positional index that is inside the valid «targetIndex» range.

See Also

• Aggregate
• Function calls and parameters
• Associative vs. Positional Indexing
• Position operator