BusinessObjects Board

Multivalue Error

server administration Web Intelligence 6.x Servers
#1

Hi,

I have a webi report in which i need to show the sedol in footer when there is single value and leave the cell blank if it throws multiple value error.

I am working in BOXI R2.

My report is attached.

I want to remove the Multivalue error

Can someone please help?
Report1.xls (57.0 KB)

sabitha (BOB member since 2010-02-18)

#2

Hi,

Why not testing the count of items ?

=If(Count([Sedol]) > 1) Then “” Else Max([Sedol])

Cedubo :belgium: (BOB member since 2010-04-27)