Why i get this value, #VALEURMULTI?

[Former Member]

Hi,

I can't see the correct value in the table, WHy? I need put this values in a graphic. How i can do that?

Here is a photo:

Thanks a lot!!!

[Former Member]

Hi Federico,

The error Multivalue comes up when a particular field has multiple values to display for a given record.

BUt given that FD Value is a Measure, it ideally should aggreagate unless other Aggregation options are given at the source level.

So in your case here, what you could possibly check is if FDValue has more than 1 Unit per record.

For instance, if FD Value is 1 GBP, 1 INR etc for the same record, in such cases there is a possibility that this error shows up.

Can you please check this?

Regards,

Srilakshmi B

[Former Member]

Hi, Sriliakshmi,

In fait, there is more than one record by mesure. So how i can take the god record?

By the wy, what means FD? in FD value.

Thanks a lot!!!

[Former Member]

Hi Federico,

FD value is the field name I got from your screenshot.

There are a multiple ways to aggregate Measure values.

One way is to separate the Units from the Measures and take just the numerical value of the Measure.

What is it that you are building your report on? Is it a BEx query?

Also how to take the good record (if incase there is bad as well) depends on your requirement and definition of good and bad records.

Regards,

Srilakshmi B

[Former Member]

Thank you Srilakshmi;

How i can separete the Units from the Measures?

Thanks;

I have always the same problem. I can't get the good data.

Thanks

[Former Member]

Federico,

On what are you building your report? Is it BEx query? Pls confirm for me to tell the way to separate Units from Measures in Query.

If not, then try the below on report:

1. Drag and drop Unit object onto the report

2. Once you do step 1, the Multivalue error should go

3. Hide the Unit column

Let me know if this works.

Regards,

Srilakshmi B

[Former Member]

Hi Srilakshmi,

It doesn't works!!!

I have not idea why i can't get the good data.

Is not a BEx Query, it is a simply query.

Thanks

[Former Member]

Federico,

Try applying Break on Field number.

The Multivalue error should go on FD Value field by showing Sum of values for every Field number.

Regards,

Srilakshmi B

[Former Member]

Federico, Change projection function of FD Value as SUM.

or else try =sum([FD Value])

[Former Member]

Hi Sujitha,

Thanks for you answer but the solutions it doesn't work.

Can you explain me what is SUM, FD Value? or tell me where I can found more information about that?

Why I need use SUM or FD Value?

Thanks a lot!!!

[Former Member]

Federico, SUM is an aggregate function which gives you the sum of measures.

At Universe level, In object properties -- change projection Functions as SUM.

If still, it is displaying #multivalue error. Then in Info View, create a variable

=sum([FD Value]) //In your screen shot FD Value object is showing #multivalues... so try to apply Sum() function and check..