#multivalue error for sum

[Former Member]

Hello,

I have a set of data like the following:

Item               Price               Allocation

------               --------               ---------------

ABC               40.00                    0.3

ABC               20.00                    0.7

DEF               50.00                    0.5

DEF               30.00                    1.5

When I try to generate a report for the sum of the prices and allocations, I get a Multivalue error.  I understand that because for each Item entry, I have multiple values, and I want to combine them together.  In the report objects, I've created a measure for sum of prices and sum of allocation, and I want the result like the following:

Item               Sum of Prices          Sum of Allocations

------               ---------------------          ---------------------------

ABC               60.00                              1

DEF               80.00                               2

However, I'm getting #multivalue error for the sum fields.  Anyone have any idea what I am doing wrong and how I can fix it?  Thank you very much in advance.

[Former Member · Accepted solution]

Hi Edward,

#multivalue error is displaying only for measures? or item object?

Change the 'Item' to dimension if it is Detail object..

If multivalue is displaying for measures...

Change the aggregated function to 'SUM' in universe level for both measures

If still the same issue then try with below formula

=Sum([Price]) in ([Item])

repeat the same to other measure...

Let us know if it not works...

Thanks,

[Former Member]

The following procedere worked for me:

-> measure [query pallets] returns #MULTIVALUE

1) create a new dimension [dimension pallets], formula: = [query pallets]

2) create a new measure [webi pallets], formula: = sum([dimension pallets])

The new measure [webi pallets] has no #MULTIVALUE.

[Former Member]

Thank you for your help and suggestions.  The issue has been resolved the following way...

The price data was a converted currency dimension, so I had to put the formula into the "Price" dimension.  After that I used Sum([Price]) forEach ([Item]) to aggregate the multivalues together.

[vinay_lohakare5]

Hello,

Make the aggregated function to 'SUM' in universe level for the measures.

Thanks,

Vinay