2 Replies Latest reply on Jun 13, 2018 9:33 AM by Jim Dehner

    Conditional formula

    TEnzin Dolma

      Hi all,

       

      I have a formula like this IF ([Data Release Dt]- [First Promise Dt])>0  then " Late" ELSEIF ([Data Release Dt]-[First Promise Dt])< 0 then "Early" else " On time" end

       

      ([Data Release Dt]- [First Promise Dt])>0 then Assign late

      ([Data Release Dt]- [First Promise Dt])<0  then assign Early

      ([Data Release Dt]- [First Promise Dt])=0 the ontime

       

      I have another field that is Revised Promise date. I want to be able to choose the revised promise date, if the data is present inorder to obtain more practical result.

      How can I integrate it into the formula?

       

      IIF (revised promise date)> (first promise date), 'revised promise date','first promise date') I tried substituting this in the formula above but failed.

       

      Thank you!

        • 1. Re: Conditional formula
          Deepak Rai

          What is the Error you are getting?

          • 2. Re: Conditional formula
            Jim Dehner

            Hi

            Consider what the data table looks like

            you have 4 columns

            and identifier - a release date - a promise date and a revised promise date

             

            This will select the promise date to use

                     date to use =     ifnull([promise_date],[revised_promise_date)  if the first argument is NOT null it uses the first argument - if it is null it uses the second

             

            THen you can use the date to use in your previous formulas

             

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.