Forum Discussion
Solved
If statement gives error token leftbracket expected
Im getting a token leftBracket expected error: I'm trying to add a "0" to the end of the field LotTxt if the length of the text is not 10. Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[...
Hi JimT99 ,
Could the left bracket error come from here. It seems like there is a double open bracket:
Here your code with the bracket in bold:
Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")
Does this solve your issue? 🙂
Hi JimT99 .
Not sure why it says this, but when I pasted your formular into my PBI the CONCATENATE function also had some small issue.
Can you try it with the following syntax?
Column = IF(LEN(Grading_data[lotTxt]) =10, grading_data[LotTxt], CONCATENATE(grading_data[LotTxt],"0"))
Let me know if this helps and do not forget to mark the answer 🙂