Hi all,
I am working on a report trying to display some data, and unfortunately, I am getting a #MULTIVALUE error.
The error is appropriate- meaning I have multiple values, and the report doesn’t know which one to display.
What I would like to do is display all of those values in one cell. Is there a way for me to tell webi to simply concatenate each of the multiple values together and display them?
Any help would be appreciated!
DuffyD 
DuffyD 
(BOB member since 2007-01-29)
Hi DuffyD,
yes you can concat and display multiple values in single cell,
try this
inset a cell
pull the velue that you want to display first
next concat with second one using + in the formula bar
example
if the first value is country,
second State and third value City you can do it this way
=[Country] +" “+[State]+” "+[City]
hope this will help you,
Reddy69 
(BOB member since 2007-10-12)
Unfortunately, I am not exactly sure how to do this. The only field that I am working with is
Lotid
Since there are multiple values for Lotid, using the concatenation function might not be helpful.
I suppose I could use
= max(Lotid)+";" + min(Lotid)
But this would only work if I have 2 values. If I have 12 values, I will lose 10 of them. How would I get the 10 values that are not max or min??
DuffyD (BOB member since 2007-01-29)
One cell cannot have multiple values… after report refresh.
How would you know LOT ID is having 12 values ? Is this column always fixed 12 values ?
For concatenation you need to know the values before hand… so that you can display 12 values… If I am guessing right, then you could create a universe object and use it in the report.
BO_Chief (BOB member since 2004-06-06)
you can solve this question by difference ways.
a. you can create function in your database and call it in your universe object see Concatenate with comma
b. in your report select horisontal table and put that field in cell + “,” , after that you can hide your columns borders and check autofit wight check box
Zara 
(BOB member since 2007-02-07)
In regards to the cell having multiple values… or having 12 values…
I used 12 as an arbitrary number…
Most of the time, each cell will have 1 value. Sometimes, it will 2, 3, or 4… and in those instances, it will come back with #MULTIVALUE.
If I put in max(value) or min(value), I will only get one of those values. Instead of putting in this min or max function, I would like to simply concatenate all of those values together.
DuffyD (BOB member since 2007-01-29)
Hi,
I am having similar issue, did you get a resolution for your issue.
pls let me know
shl (BOB member since 2007-06-05)
Hi Duffy,
You can do as what Zara has suggested in his 2nd option.
Create a Horizontal Table and remove the header column (remember, since this is a horizontal table, header will be a column and not a row). In the single cell which would be displayed now, insert the “lotid” object. Adjust the size as you want. This would display all the lotid’s in horizontal way.
Hope this is what you wanted.
Thanks,
Srivatsa
srivatsakr (BOB member since 2007-07-27)
The horizontal table approach works fine for displaying one row spoofed to look like a single cell, but I still want to concatenate all the values into a single cell. The reason I want it in a single cell is to pass to an InList prompt in a hyperlinked report.
In my example we have [sites] and [systems]. Some sites have more than one system. So in my case I want a list of the site values in one column, and in the next column I would like a concatenated list of the [systems] associated with that [site] separated by a ; (to pass to the prompt of the site details report - can’t pass the site itself because of inconsistencies between data sources).
In my example even the horizontal table trick fails. The Max and Min suggestions work when there’s only 2 (or if it’s just a spelling difference and you don’t care which it displays). I can create a crosstab with site in one dimension and system in the other (and a fancy if then statement in the body to only display if there’s a match), but then most of the body cells are empty.
So far I think it’s impossible at the report level. Since everybody just uses + instead of the concatenate formula, I’d hope BO could augment the formula with the ability to concatenate multiple details associated with an object (or vice versa multiple object values with the same detail value) instead of just showing #multivalue… 
dorothy (BOB member since 2010-06-17)
Hi,
Have you tried using Previous(SELF) function along with few context operators for your requirement?
Thanks!
bodevXI (BOB member since 2006-05-09)
Now that was a good hint
OK it’s not all the way there but closer than I’ve ever been before. The remaining issue I have is that I still need to list alll the systems in a site for the “previous” to know what to refer to. the last system for that site has the concatenation, and the hyperlink works to an inlist prompt. For some reason when I made the below formula into a variable BO chose to make it a measure. Changing the variable from a measure to a dimension, and suddenly it didn’t work anymore.
Here’s my formula that successfully concatenates three of the Multivalues and can be extended recursively to handle more than three:
=[System] + If IsNull(Previous([System];([Account]);1)) Then “” Else “;” + Previous([System];([Account]);1) + If IsNull(Previous([System];([Account]);2)) Then “” Else “;” + Previous([System];([Account]);2)
dorothy (BOB member since 2010-06-17)
The solution i am looking for is exactly what’s been reported here. The only problem users have with my current solution is the order displayed is in descending order.
Looked at ure formula u stated in the earlier post. Does that really work? I am not able to figure out what does this mean
Previous([System];([Account]);1)Does this parse at all? Trying to figure out if their is any other extended syntax that uses second “;” in PREVIOUS function 
BTW we use XIR2 against DB2 database. Need help.
Thanks.
boe_bods 
(BOB member since 2008-03-14)
[System] and [Account] are dimension objects. Each [account] has multiple [systems], so yes, it is extended syntax in the formula. it will show three of the accounts systems.
You can aways use the formula help function to see each formula’s syntax.
dorothy (BOB member since 2010-06-17)
Hi Duffy,
i think using reportfilter function, we can do this
reportfilter(lotid)
the result is, the lotid cell contains those 12 values.
rbogireddy (BOB member since 2011-06-13)
as brkr mentioned. for using ReportFilter option you can add an input control (Combo Box) to the report for LOTID and and select All values and it will give you the list of all LOTID with separated by ;
jprasanthram 
(BOB member since 2010-12-10)
Nice… Almost there…
It seems to work when one selects values on the input controls, however I’m still getting the #multivalue when I choose “select all” (from a combox box or a multi select input control)
Closest yet at least…
dorothy (BOB member since 2010-06-17)
@dorothy: Check the screen print attached. Each ParentID has multiple Contact Code as is in your case. Check the error it returns when i am trying to implement the previous function. 
Am i missing something here? I still think the “;1” is not part of the Previous function. Can you please provide the Webi version of the same formila 
Thanks.
boe_bods 
(BOB member since 2008-03-14)
Does anyone has formula that can be extended recursively to handle more than three.
Thanks.
JohnJustus (BOB member since 2007-06-25)
Hi All
You can have a look at this solution
Thanks
siraj03 (BOB member since 2011-04-28)
Hello , I am facing the same issue, the only difference is that that I haven’t got “system” for each “accounts”. I have tried your solution as well but as far as I delete “system” I receive multivalue.
Hajnalka 
(BOB member since 2013-03-22)