Computation errors
#COMPUTATION in cumulative aggregations
#COMPUTATION occurs in cumulative aggregations for the following reason:
• The reset context is not included in the output context.
Solution for #COMPUTATION in a cumulative aggregation
To avoid #COMPUTATION in a cumulative aggregation, the reset context must
be included in the output context. In other words, the dimension or dimensions
after the semi-colon (;) in the formula must also be listed after the operator (In,
ForEach or ForAll) on the right of the formula.
#COMPUTATION in non-aggregate formulas
In non-aggregate formulas, #COMPUTATION occurs because the output context
is not included in the input context
Solution for #COMPUTATION in a non-aggregate formula
You must:
1. Edit the formula so that the output context is included in the input context, as
described in the example above.
2. Add Max or Min to the beginning of the formula, followed by an opening
parenthesis.
3. Add a closing parenthesis at the end of the formula, then press Enter.
#MULTIVALUE
#MULTIVALUE in aggregations
#MULTIVALUE occurs in aggregations because
The output context is not included in the local context.
#MULTIVALUE in break headers and footers
#MULTIVALUE in a cell at the section level
A report section displays data in a master cell and in a block or blocks. If you use
two variables at the section level, #MULTIVALUE can occur.
Read more »