Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Feb 02, 2022
Solved

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])    
access
  • George_Hepworth's avatar
    George_Hepworth
    Feb 02, 2022

    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])

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Feb 02, 2022

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
    Iron Contributor
    Feb 02, 2022

    George_Hepworth 

    Hi George,

     

    Its works now: 

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

     

    thank you

Resources