#MULTIVALUE Error

In Operator is used to specify exactly which dimensions to include in a context. Other dimensions in the block are ignored. Adding / removing elements from the block does not impact this calculation unless a removed dimension was specified in the context. In that case a #MULTIVALUE error is displayed.

If there are multiple rows in a report with what appears to be the same data, and the measure being displayed is not set at the universe level to automatically aggregate, the MULTIVALUE error will appear.

1. Use measure objects that are named "SUM", if they exist - e.g., SUM Actual Month (BAL) rather than Actual Month (BAL) in the FINQUERY Balances folder. This ensures that the balance amount will be properly aggregated based on the dimension objects selected in your query.
2. Create your own variable to sum the measure within the table (you'll need to do this in all tables in the report, though).
3. Within the table properties in InfoView or Webi, check the box to under Display to "Avoid duplicate rows aggregation". Note that this feature only exists for tables, and not crosstabs.

Note:Every measure object should be defined Aggregate function in select statement
Note:use Proper Calculation context syntax

Example:

1) #multivalue in aggregation

2) #multivalue in breaks header or footer

3) #multivalue in section level.

1:-- the o/p context not include i/p context its  situation

this error occurs.

Ex: in a report i have year,city dia's & Revenue measure is

there.

         =<revenue> In <year>

The above condition will to run the query getting revenue

column #multivalue error occurs.

solution: cilck the formulabar in view menu

         select the error containg cell, edit the formula to

write below condition.

= <revenue> In(<city>,<year>) In <year>

The above formula will run correct data will appear in the

report.

Note: the above condition by default it will take agg "sum"

function.

#syntax:--

          the variable in the formula no longer exist in the

condition.

Ex:- <product price> * <quantity sold>

The above condition will run this error will occur.

Solution:- Click edit dataprovider--> new object will be

need --> select error cell --> edit formula --> click ok.

#error:--

         the variable in the formula is incorrect. this

error will occur.

solution : go for data menu --> click variable

select the error containing a cell --> copy the formula in

edit menu --> paste it in new cell --> go for formula bar in

view menu -->  --> take the first error containg cell

-->edit the formula --> repeat the above steps.

#MULTIVALUE occurs when you place a formula that returns more than one

value in a cell that outputs one value only.

Example: Multivalue in a cell

You have a report showing Country, Resort and Revenue and you add a cell

to the report containing the formula [Revenue] ForEach ([Country]).

This cell returns #MULTIVALUE because Country has two values in the

report: u2018USu2019 and u2018Franceu2019.

One cell cannot display the revenues for both the US and France. Placed

outside the table, a cell containing revenue can only aggregate the revenues