3 Replies Latest reply: Mar 11, 2014 2:31 AM by Helen Betty RSS

    If statement in script - Error in expression: ')' expected

      Hi folks,

       

      while using following if statement in the load script I get the error: "Error in expression: ')' expected"

       

      if(delta <= -3, 'Early > -3',

        if(delta <= 1, 'Early/+1',

        if(delta >= 1, 'late',

        if(delta >= -3 AND <= 1, 'On Time', 'n/a')))) as Delta_Classification,

       

      Surfing different discussions they give the advice to use IF...THEN...END IF.

      Nevertheless there wasn`t an example for multiple conditions like I have to use.

       

      Can somebody help me?

       

       

      Many thanks!