3 Replies Latest reply: Mar 26, 2018 10:10 PM by THIAGO TEIXEIRA RSS

    System Logic

    RAM MUTHIAH M

      I want to show the system for the project # based on the logic given below

       

      Output:

      Project #, System, Date

      1,              D,         6/2/2018

       

      Project

      System

      Finish Date

      Current State

      Based on the logic, I want to show the system where current state is equal to 1 and based on maximum Finish Date

      1

      A

      30/07/2017

      1

      1

      B

      23/09/2015

      0

      1

      C

      29/11/2015

      0

      1

      D

      6/2/2018

      1

      1

      E

      25/07/2017

      0