#VALORMÚLTIP #MULTIVALUE no possible to create breaks

[Former Member]

Hi,

I'm dealing with the already known error message #MULTIVALUE and, even if there are lots of posts around, I couldn't solve mine.

Here you have how my report looks like:

In report you can see vendors in columns ("Proveedor") showing 3 KPI's:

- Value ("Importe")

- Quantity ("Cantidad")

- Price ("Precio")

For each vendor there are two kinds of quantity keys: EA (each) and KG. You can see in the bottom of the report the sum of values. For Value (Importe) is doing great as it's summing EUR+EUR (easy!), but when summing EA + KG... #MULTIVALUE error appears.

I've tried many possible solutions, nothing solved my issue. I've put unit key as dimension after Vendor and hiding it, nothing solved.

I've also tried the following solutions:

http://www.forumtopics.com/busobj/viewtopic.php?p=966743&sid=4083c4a714b2b76f7a9e462184cb7065

http://scn.sap.com/message/14047520

http://scn.sap.com/thread/1919325

http://scn.sap.com/thread/3238803

http://scn.sap.com/thread/1342303

What the report should display is 4 result rows, 2 for each kind of quantity: total value and quantity for EA, and total value and quantity for KG.

Any suggestion?

Thanks in advance!

[arijit_das · Accepted solution]

You need to create 2 separate footer rows for EA and KG respectively.

Use formula for total as:

=Sum([Quantity] where ([Unidad]="EA"))

and

=Sum([Quantity] where ([Unidad]="KG"))

You can then hardcode the units for total.

[Former Member · Accepted solution]

Hi Arijit,

Your solution is not feasible as in this case units are EA or KG, but there could be many other types of unit, I cannot display lots of footers.

What I need is a result break by unit, and I don't know how to do it.

Thanks

[sateesh_kumar1 · Accepted solution]

HI Alberto ,

I think your columns are static , so you can try adding a report block with Quantity unit as dimension and key figures.

Then append your new block to the main table with relative position :bottom 0.

make sure your column width is fixed in both tables , that gives you only table exists in the report.

[Former Member · Accepted solution]

Hi Sathish.

It's not a bad idea, however there are two things make me doubt about this solution:

- If I filter for the main table (right botton -> filter), this filter doesn't apply to the new report block. If you know how to link those filters...

- Format, it's really hard to get the same format so as to align both report blocks.

Thanks

[sateesh_kumar1 · Accepted solution]

Hi Alberto ,

If you use Reportfilters then you don't want to do anything , it'll affect entire tab.

If you are using Input controls/Element link then you should apply the dependency to the new block also.

Formatting : we should fix the all columns width with the same number , so that it can be as like as one.

[Former Member · Accepted solution]

Thanks a lot Sathish, I'm going to build the report according to your advises

However, I have to say it's unbelievable a so huge and complex BI software as BO is has so ugly and almost useless solutions for many things, I think they should improve a lot in next version.

Thanks

[sateesh_kumar1 · Accepted solution]

Hi Alberto,

We feel it as , but as you know there is nothing perfect,,Bo has its great features and flexibilities and some frustating,,,,too.

But it'll be the best reporting tool going forward,

[Former Member]

HI Alberto,

did you try this for EA+KG = SUM(ALL Values)-sum(EUR)?

Regards

Subbarao M