9 Replies Latest reply on Sep 4, 2018 7:32 AM by Simon Runc

    Calculation: Looking up the lowest turnaround time (including blanks) for each unique ID

    Kamin Au

      Hello,

       

      Very sorry if this is already posted, but I couldn't figure this one out myself, any help is much appreciated, thank you!

       

      See attached Excel... here is some context:

      - Each unique ID created should have an identifier that is added either immediately or later

      - Column D gives the days it took for the identifier to be added to the unique ID HOWEVER there are duplicates in the data

      - I want a calculation that tells me for each unique ID (22 in total in this example) what the turnaround time was (i.e. give me results such as 0 days, 15 day or not yet available)

       

       

      I have tried these but it does not give me the correct result as it double counts

      {FIXED [Unique ID] : MIN([Days for Identifier to be added to the Unique ID])}

       

      Also tried this:

      IF [Days for Identifier to be added to the Unique ID] = 0 THEN "IMMEDIATE"

      ELSEIF [Days for Identifier to be added to the Unique ID] > 0 THEN "LATER"

      ELSE "NOT YET AVAILABLE"

      END