3 Replies Latest reply: Dec 5, 2017 2:27 AM by john lewis RSS

    if

    Agrim Sharma

      Hi, i want to get this condition, where i am getting correct output for "ahead of schedule" and "Behind Schedule" but not getting correct results for:-

      Schedule variance >= -10% to 0%, on schedule,

       

       

      desired condition:-

      Schedule variance>=0%, ahead of schedule

      >= -10% to 0%, on schedule,

      <-10%, Behind Schedule

       

       

      Condition made-

      IF("Schedule Variance">='0%', ' Ahead Of Schedule',

      IF("Schedule Variance"=1, 'On Schedule',               ------here i want 0% to -10%

      IF("Schedule Variance"<'-10%', 'BehindSchelule'

                ))) as Schedule_Classification

        • Re: if
          aparna v

          Try this,

          IF("Schedule Variance">='0%', ' Ahead Of Schedule',IF("Schedule Variance"<'-10%', 'BehindSchedule','On Schedule'

                    )) as Schedule_Classification

          • Re: if
            Anil Babu

            Normally percentage calculate in Decimal like 10$ - 0.1 and so on. I assume, In your case it has like below

             

            IF("Schedule Variance">=0.0, ' Ahead Of Schedule', IF("Schedule Variance"=1, 'On Schedule',  IF("Schedule Variance"< (-0.1), 'BehindSchelule'))) as Schedule_Classification

            • Re: if
              john lewis

              Try this...

               

              IF("Schedule Variance">='0%', ' Ahead Of Schedule',

              IF("Schedule Variance"<='-10%' and "Schedule Variance" <'0%','On Schedule',

              IF("Schedule Variance"<'-10%', 'BehindSchelule')

                        )) as Schedule_Classification