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.