14 Replies Latest reply on Jul 20, 2016 6:11 PM by Yvonne Cheng

    Obtaining Information with one tracker

    Yvonne Cheng

      Good Day,

      I would like to have a report which shows a list of crew on board the vessel from which Master sign off in last week.

      For example, one Master sign off vessel Hanjin Mexico in last week(16/Jul/16). I would like to have a list of crew who are currently onboard Hanjin Mexico.

      To define crew onboard: Start Status: CONF AND End Status: PlAN. To define crew sign off: Start Status: CONF AND End Status: CONF.

      In my opinion, the tracker should be vessel name. So I create this logic:

      But it only gives me Master who sign off instead of on board crew.

      Here attached with a sample workbook. Appreciate you could help me.

      Best Regards

      Yvonne