Limitations When Using Clauses in Summary Functions

A summary function that uses a for clause may yield unexpected results. These may include error messages, warnings, incorrect numbers, and more or fewer than expected rows, columns, or chart points and lines.

To avoid these problems, ensure that the parameters that follow the for clause adhere to the following constraints:

Parameters must be simple data item references.
All data items in the parameter list must appear on every list, crosstab, or chart that uses that summary.
For any edge used in the for clause, data items listed in the for clause must start with the first data item on that edge.
Data items must be listed in the order in which they appear on each edge of the report with no gaps.
In crosstabs and charts, there must be no sibling data items that are considered details. Summaries are normally not considered details.
Section headers must not be included in the parameter list.

If following these constraints does not resolve the problems and your report uses dimensional data with no detail or summary filters, consider using the within set clause instead of the for clause.