Multivalue error in Crosstab in Webi

[former_member334960]

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!

[former_member182342]

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