New Bug Encountered: Sytax Checked on IN()

This has happed a few times to in the last 24hrs so I thought I’d report it.

When I tried to use this formula
IN([_ThisRow].[Cable Name],[CableID])

I got
Parameter 2 of function IN is of the wrong type

Which isn’t very intuative because all that was wrong was that [CableID] should have been [Cable ID]

IN([_ThisRow].[Cable Name],[Cable ID])
works fine

I can imagine someone getting hung up on this for an hour or so and presume its a simple fix

Did you have a column name CableID at all?


Doh, yes. Thanks @Aleksi I’ll keep an eye on this in case the bug is still relevant elsewhere