Skip to Content
0

Avoid #multivalue error webi 4.2

Apr 07, 2017 at 10:40 AM

190

avatar image

Hi guys

In one of the reports developed by my end users, they are having multivalue error in some of the rows where there are more than 1 value for an object:

Here is the sample data":

Yr1 = If( ([start date]<= (RelativeDate('31/03/2017';-365)) And [end date]>= (RelativeDate('31/03/2017';-365)));"Yes";"")Yr2 = If( ([start date]<='31/03/2017' And [end date]>='31/03/2017');"Yes"; "")

Yr1 Price =NoFilter(([price] Where ([Yr1] = "Yes") In ([Key1])) )

Note: there is a filter on report to only show values where Y2 is not null

Yr2 Price = [price] Where ([Yr2] = "Yes") In ([Key1])

[Key1] = [Contract]+[job no]+[skin code].[Contract Id]+[location]

Any ideas guys how to avoid this error?

yuju2.png (12.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Apr 07, 2017 at 11:08 AM
0

try this.

Yr2 Price =Sum([price]) In ([skin code])

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I forgot to mention that this is just a sample, the data has multiple contracts,job no, skin codes and contract ids

0

instead of placing Key1 variable,place all objects under the IN

0

does not work... did not return anything...

0