2 Replies Latest reply on Jul 25, 2018 9:58 PM by Ankit Bansal

    Equation structure

    Abdulbari Shaeban

      Hi

       

      Could you please identify what's missing here

       

       

      IF ATTR([iPMS-ReadinessAll].[Grant Agreement Type])='framework agreement'

      THEN

      DATEADD('month',4,ATTR([Final Merge (Disbursement Schedule and Reporting Dues 123)].[IPR2 due (Copie final)]))

      IFNULL(ATTR([Final Merge (Disbursement Schedule and Reporting Dues 123)].[IPR2 due

       

       

      The error message shows " Expected "ENd' to match if

       

       

      Thanks in advance

        • 1. Re: Equation structure
          Zhouyi Zhang

          Hi, Abdulbari

           

          the structure is something like

           

          if your 1st condition then

               your expression

          elseif your 2nd condition then

               your expression

          else

               your expression

          end

           

          Hope this helps

           

          ZZ

          • 2. Re: Equation structure
            Ankit Bansal

            Abdul,

             

            Can you paste your full formula. If your second condition is to check null value you should go like this:

             

            IF ATTR([iPMS-ReadinessAll].[Grant Agreement Type])='framework agreement'

            THEN

            DATEADD('month',4,ATTR([Final Merge (Disbursement Schedule and Reporting Dues 123)].[IPR2 due (Copie final)]))

            ELSEIF ISNULL(ATTR([Final Merge (Disbursement Schedule and Reporting Dues 123)].[IPR2 due.....

            then......

            else ....

            end

             

            Last else is optional.