6 Replies Latest reply on Apr 4, 2018 6:53 AM by David Konjetic

    TIMEVALUE in Tableau

    David Konjetic

      Hi

       

      I have the below formula in Excel and i need this to translate in Tableau

       

      Excel formula

      =IF(AND(G6="URGENT",U6=K6,L6<=TIMEVALUE("18:00:00")),"On Time",IF(AND(G6="P3 NEXT DAY"),"On time, apart from exception list",IF(AND(G6="P1 NON EU",U6=K6,L6<=TIMEVALUE("15:00:00")),"On Time",IF(AND(G6="P2 EU",U6=K6,L6<=TIMEVALUE("15:00:00")),"On Time","Late"))))

       

      G6 = [Part Order Line Shipment Priority]

      L6 = [Part Delivery LPN Creation Date]

      U6 = [Part Order Line Pick Release Date]

      K6 = [Part Delivery LPN Creation Date]

       

       

      Tableau formula

       

      IF(AND([Part Order Line Shipment Priority]="URGENT",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("18:00:00")),"On Time",IF(AND([Part Order Line Shipment Priority]="P3 NEXT DAY"),"On time, apart from exception list",IF(AND([Part Order Line Shipment Priority]="P1 NON EU",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00")),"On Time",IF(AND([Part Order Line Shipment Priority]="P2 EU",[Packed same date]=0, [Part Order Line Shipment Priority]<=TIMEVALUE("15:00:00")),"On Time","Late"))))

       

      I have have already translate already most of the formula but the only piece of the formula i can translate is the TIMEVALUE.

      how know how i can do this?

       

      thanks