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
forclause, data items listed in theforclause 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.