10 Replies Latest reply: Nov 4, 2014 7:26 PM by Christoph Thalner RSS

    Current Work Day

    Fabio Alamini

      Guys,

       

      I'm struggling with something that should be a quick aggr function with rank.

      I have my booking dates and want to show it by WORK DAY. Like the example bellow.

       

      How can I calculate the yellow column?

       

      BOOKING_DATEBOOKING_DAYBOOKING_WORKDAY
      9/2/201421
      9/3/201432
      9/4/201443
      9/5/201454
      9/8/201485
      9/9/201496
      9/10/2014107
      10/1/201411
      10/2/201422
      10/3/201433
      10/6/201464
      10/7/201475
      10/8/201486
      10/9/201497
      10/10/2014108

       

      Thanks,

      Fabio