Converting an Excel statement to Spotfire Expression

[Damilola Adeyemi]

Hi Team,

I have been trying to get this expression working.I have been struggling with the conversion syntax in Spotfire, trying to compare a string with an integer.

Please help

Case

 

When Len([ComsumerID] = 5 ) then "Individual"

 

ELSE "Other"

 

End

 

Excel function and it worked

=IF(LEN(I2)=5,"Individual","Other")

[Gaia Paolini]

It is not conversion syntax. There is a misplaced parenthesis: you are not closing the round bracket after the square.

Case

When Len([ComsumerID]) = 5 then "Individual"

ELSE "Other"

End

Please also check the column spelling (unless it is actually spelled with m in your data).

Gaia