2 Replies Latest reply: Feb 8, 2018 2:03 PM by Steven Koolen RSS

    Error in query

    Steven Koolen

      Hello all,

       

      I want to make a calculated field based on an amount in the query.

       

      IF([Invoice Due Age]<= 0, 'Not overdue',

      IF([Invoice Due Age] >= 1 AND [Invoice Due Age]<=30, '0-30',

      IF([Invoice Due Age] >= 31 AND [Invoice Due Age]<=90,'30-90',

      IF([Invoice Due Age] >= 91 AND [Invoice Due Age]<=120,'90-120','120+'))))

       

      It works when I don't have an AND condition in the query, but as soon when I have that it keeps giving the error Missing right parenthesis.

       

      What am I doing wrong?

       

      Thanks in advance.