IF statement using length

I am trying to copy the below IF statement that is used in Excel into a calculated field in Looker

=IF(LEN(E2)<=4,"BPC","PICK") 

I can’t get my head round it

0 1 296
1 REPLY 1

Dawid
Participant V

You can use length function in Table Calculations, explained here: https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators#st...

4176fe58-e0e2-4224-b231-7c4302fbf516.png
Top Labels in this Space
Top Solution Authors