Multivalue

building reports desktopintelligence
1

In BO IV I have a dimensions [LT] with values between 0 and 120.
When I create a bucket variable [category] like:
If [LT] >= 2 Then “low” else “High”
And I select in my report [LT] and [category] I get a list with
0, low
1, low
2, low
3, high
4, high
etc. etc.
When I remove [LT] from my report, I get #Multivalue.
I expected to see
Low
High
(for further use in the report)
Is there a correct way to avoid this.
thnx in advance

MennoBlaauw :netherlands: (BOB member since 2011-11-09)

2

=[category] ForEach([LT]) should do the trick

You’ve taken LT out of the calculation context by removing it from the block; category therefore evaluates itself against each LT and doesn’t have a single answer for that cell so gives up and spits out #MULTIVALUE

3

Thnx, I will try this.

MennoBlaauw :netherlands: (BOB member since 2011-11-09)