6 Replies Latest reply on Jul 4, 2017 3:53 AM by Donna Coles

    I NEED HELP WITH A FORMULA

    AJ.Yusuf

      Formula below needs to be a nexted if function with index numbers as <4 and <3, I am confused how do i do this>Its not valid at the moment

       

      IF INDEX()<4 THEN

      IF LOOKUP(SUM([Invoices]),0)>LOOKUP(SUM([Invoices]),3) THEN

      1

      ELSE

      0

      END

      ELSE

      IF

      LOOKUP(SUM([Invoices]),0)>LOOKUP(SUM([Invoices]),-3)THEN

      1

      ELSE

      0

      END

      ELSE

      IF

      INDEX()<3 THEN

      LOOKUP(SUM([Invoices]),0)>LOOKUP(SUM([Invoices]),2)

      THEN

      1

      ELSE

      0

      END

      ELSE

      IF

      LOOKUP(SUM([Invoices],0)>LOOKUP(SUM([Invoices]),-2) THEN

      1

      ELSE

      0

      END

      END

      END

      END