#MULTIVALUE Error

building reports webintelligence
1

Hi All,

i getting the #MULTIVALUE Error while using the below formula for my object.

=If([Count of Contracts]>1;""; [Equipment System Name])

i dont want to Check the Apply Duplicate Rows Aggregation…

Please let me know is there any workaround for this.
i applied Min(),Max() and …but no Luck :hb:

kalyanswarna :india: (BOB member since 2005-12-07)

2

Try top bring [Count of Contracts] into one of the columns and and look at the values it is giving.
Then try to bring your object in the column next to it. I think its more to do with your “[Count of Contracts]” object. Can you post the formula you are using for that object.

rimpa :india: (BOB member since 2008-04-14)

3

Hello,
Thanks for your Reply, i have already tested my Count of Contracts Variable, working fine.

My Requirement is i have CustomerID----------->Contract Id(hierarchy) there is a possibilty some of the Customers having more than one contract id, if the Customer having morethan one contractid i have to show blank in another column called SysName else sysnema of that customer.

Thanks,

kalyanswarna :india: (BOB member since 2005-12-07)

4

Is you SysName associated with Customer ID or Contract ID? In any case you formula won’t work. Try using something like this:

=If((sum([Count of Contracts])in [CustomerID])>1;""; [Equipment System Name])

rimpa :india: (BOB member since 2008-04-14)

5

HI Kalyan,

You can use the function ISError
so that whenever there is MUlti Value you can replace it with blank

thank you,
varun

malyalavarun (BOB member since 2006-07-01)

6

Hi Rimpa,
i used your formula then also i am getting the same Issue, here the MULTIVALUE is not coming for all the rows, only for one row its coming.
for eg if i ahve 4 rows for these 4 rows 3 are coming with data and one is with MULTVALUE.

if i check the Aviod Duplicate rows Aggregtion i am getting the cirrect result with out Multivalue error but ineed to Do the Duplicate Rows Agregation.

Please help me Out.

Thanks,
Kalyan
BO-Sample.JPG

kalyanswarna :india: (BOB member since 2005-12-07)

7

Try using similar formula for all the columns that are getting MULTIVALUE. It looks like they have One-to-many relationship with Customer ID.

If this doesn’t work, please provide details on what kind of values are you expecting in those columns. You Just talked about SysName till now.

rimpa :india: (BOB member since 2008-04-14)

8

Hi ,
I applied same formula for all the columns,but no luck, the values are strings.

Please help me

kalyanswarna :india: (BOB member since 2005-12-07)

9

You need to explain the relationship b/w CustumerID and the columns that are getting multivalue error. Is it one-one or is it one-many . If it is One-many , you need to tell which one of those values do you want to see. You can use functions like max() or min() to show only one value corresponding to the customer id.
I am sorry to say but your description of the scenerio isn’t very clear.

rimpa :india: (BOB member since 2008-04-14)

10

I understand the problem exactly because I have the same problem. It only seems to happen with the first row of the dataset and there is no reason why it would do this.

I think it may be a bug, I would raise a support case.

rdjmoose :uk: (BOB member since 2005-08-08)