Error Messages/41093

Error Message Examples

The <<map>> parameter of Aggregate contains a non-numeric position at @IndexI =9.
Since the positional:true parameter is specified for Aggregate, the positions in Map
must be numeric positions along the targetIndex (or null).

Cause

When the <<positional>> parameter to the function Aggregate is specified to the true, the <<map>> parameter to the function must be numeric and a positional index of the <<targetIndex>> parameter. At least one cell in the passed in <<map>> parameter contains a non-numeric value that is not allowed.

Click here 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 numeric positional index that is inside the valid <<targetIndex>> range.

Loading comments...