0 Replies Latest reply: Aug 10, 2012 3:05 AM by Kumar M RSS

    Expression/Script required

    Kumar M

      Hi,

       

      In the below table, Show field need to be calculated as expression or during scripting.

      1) For category if there is a first initial date exists and there is no Actual date, status of that record need to be shown in Show Column.
      2) If both initial date and actual date exist then status of next record to be shown in Show column.

      3) If all status has initial and actual date then Show column should show 'Complete'

       

      CategoryStatusInitialActualShow
      C1A16-01-2012 A
      C1B
      C1C
      C2A18-08-201118-08-2011B
      C2B05-12-2012
      C2C11-07-2013
      C3A16-12-201016-12-2010C
      C3B16-12-201016-12-2010
      C3C26-04-2012
      C4A11-08-201111-08-2011Complete
      C4B01-06-201205-06-2012
      C4C26-07-201226-07-2012

       

      Please find the sample attached file.

       

      Thanks,