Skip to Content

Multivalue error in Crosstab in Webi

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded