If statement gives error token leftbracket expected

[JimT99]

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[[LotTxt], CONCATENATE(grading_data[LotTxt]),"0")

[tackytechtom]

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 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom · Accepted solution]

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? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[JimT99]

yes...that was it. (Embarassed).  Now it tells me that "If" isn't recognized.

Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly.