Variable to get rid of "#MULTIVALUE" Error

building reports webintelligence
1

Hi All,

I want to create a variable which can replace the “#MULTIVALUE” error with some text. I tried to create it as follows:

=If(Count([L01 Destination]) > 1 And [L01 Destination]=[Region]) Then "Multiple Regions"

But it again displays #MULTIVALUE. Can anyone help me to create this variable.

I have done some analysis for the above variable and found that the condition

is returning wrong results. When I am displaying the [L01 Destination] in a column it is returning two values which is correct.
Can anyone tell me why count() is returning 1 instead of 2?

Regards,
Rohit[/quote]

rohit12 :india: (BOB member since 2008-11-08)

2

Your formula looks like it might need some tuning…

Highlight your block, go to properties, display and tick ‘Avoid Duplicate Row duplication’

jemstar :ireland: (BOB member since 2006-03-30)

3

Just replace [Destination] by Max([Destination])

rktarapore (BOB member since 2006-11-14)

4

Just replace [Destination] by Max([Destination])

rktarapore (BOB member since 2006-11-14)