Skip to Content
0

Multivalue error in Crosstab in Webi

Oct 31, 2017 at 01:56 PM

29

avatar image

Hi All,

I have created two variables:

Max Seq : =Max([Sequence 2]) In ([Planned End Year Quarter]; [Project])

State no. for Seq : =If ( ( [Sequence 2]=[Max Seq]);[State Number];6)

The above works fine when I use them in a horizontal table, but when I use them in a cross tab, I get multivalue error, Can someone please suggest on this?

vertical-table.png

crosstab.png

Attached the error.

Thanks!

vertical-table.png (11.5 kB)
crosstab.png (8.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 31, 2017 at 02:40 PM
0

Hi Poojitha,

Can you quick check by just adding dimensions in the crosstab and which dimension is resolving your #multivalue issue then just add that dimension in Foreach condition of formula.

Regards,

Anish

Share
10 |10000 characters needed characters left characters exceeded