Filter question

[garretwalters12]

The following formula is showing as a malformed if statement:

if Length([state]) = "2" then [State2] else [state]

Both State columns are listed as string data types

[Thableaus · Accepted solution]

Hi @garretwalters12 

You missed an ENDIF at the end of your formula.

Besides, Length formula results in a number, it can't be a string. 

if Length([state]) = 2 then [State2] else [state] ENDIF

Cheers,