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