User receives an error using PARTITION_AGGR with a sort field in a DEFINE field: FOC1801

Diagnostics

Product: InfoAssist

Release: 8206

Primary OS: Windows

Solution Date: 2020-12-09

Symptom

(FOC1801) cmpbifun: logical error during parsing stage, function PARTITION_AGGR. expected number of parameters: 5, actual number of parameters: 4

Problem

The user receives the error message above when using a PARTITION_AGGR function with a sort field in a DEFINE field.

Solution

The PARTITION_AGGR function is only supported in a COMPUTE statement because it requires the internal matrix within the sort field. Use the PARTITION_AGGR function in a COMPUTE field instead of a DEFINE statement.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.