0 Replies Latest reply: Apr 18, 2017 9:31 AM by Sebastien Colaux RSS

    Highlight data from previous day if ...

    Sebastien Colaux

      Hello,

       

      I'm trying to highlight some data on a table depending if the value of DB_VehMat is present in a consecutive day.

       

      BD_dateDB_VehMat
      01/01/2016123aze
      01/01/2016456qsd
      01/01/2016789wxc
      02/01/2016123aze
      02/01/2016896edc
      02/01/2016963tgj
      03/01/2016123aze
      03/01/2016456qsd
      03/01/2016963tgj

       

      In this exemple, if DB_VehMat is present the next day, I'd like the first one to be highlight in red.

      If the DB_VehMAT is there during 3 consecutive days, I'd like to highlight the first 2. (and so on ...)

       

      Ergo, the result should be something like this :

       

      BD_dateDB_VehMat
      01/01/2016123aze
      01/01/2016456qsd
      01/01/2016789wxc
      02/01/2016123aze
      02/01/2016896edc
      02/01/2016963tgj
      03/01/2016123aze
      03/01/2016456qsd
      03/01/2016963tgj

       

      I think the best way to solve this problem is with the Set Analysis but I can't manage to write a expression which is working as expected.

       

      According to me, the solution should be something like this :

       

      =if(DB_VehMat = "...  I need help day+1  ...",red())

       

      Thanks a lot for helping.

       

      S.Colaux