SAP Knowledge Base Article - Preview

1206426 - Errors: "#MULTIVALUE" or "#COMPUTATION" when using the 'Previous' function in a cross tab


When using the Previous function in a cross tab, one of the following error messages appear:




Steps to duplicate:

1. Create a new Web Intelligence document using the sample e-fashion universe

2. In the query result objects place the State, City, Week, and Sales Revenue fields then run the query.

3. Create a cross tab with the Week dimension running across the top of the cross tab, State and City down the side and Sales Revenue in the body.

4. Place a break on State.

5. Place a sum on Sales Revenue.

6. Insert a row below the sum row in the break.

7. Create a new variable with the following formula:

=Previous([Sales revenue])

8. Place this variable in the empty row you have just created and place it directly beneath the sum values.



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


Incorrect behaviour of previous function , 9135003 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.