Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Feb 02, 2022

Closing Parenthesis error

Hello 

I get a closing parenthesis error but I have added it.  I dont see what else I am missing? 

 

StrippedInv: iif(Iserror(StrippedChar([Invoice No]),"",StrippedChar([Invoice No])

 

 

  • Tony2021 

     

    I do believe there IS a missing closing parenthesis or two.

    Count the opening ( parens and the closing ) parens. There is at least one more open than close.

     

    StrippedInv: iif(Iserror(StrippedChar([Invoice No]),"",StrippedChar([Invoice No])

  • hello sir

    our option and expiation on this is that it maybe a bug. I would suggest to turn off and on again, and do what you are doing again

    • Tony2021's avatar
      Tony2021
      Steel Contributor
      Hi, I tried and unfortunately no change. I still get the error after closing out the database completely. Any other suggestions?
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    Tony2021 

     

    I do believe there IS a missing closing parenthesis or two.

    Count the opening ( parens and the closing ) parens. There is at least one more open than close.

     

    StrippedInv: iif(Iserror(StrippedChar([Invoice No]),"",StrippedChar([Invoice No])

    • Tony2021's avatar
      Tony2021
      Steel Contributor

      George_Hepworth 

      Hi George,

       

      Its works now: 

      StrippedInv: IIf(IsError(StrippedChar([Invoice No])),"",StrippedChar([Invoice No]))

       

      thank you

Resources