4 Replies Latest reply: Sep 18, 2015 8:30 AM by Marcus Sichel RSS

    I need Help with tracking bookings based on date ranges

      I need to do two things with my data.

       

      First I need to be able to show what's been booked on a rolling weeks basis. I've tried the below but can seem to get it to work:

       

      =Sum({$<BOOKINGDATE=P({1<BOOKINGDATE={">=$(=Today()-7)<$(=Today())"}>}BOOKINGDATE)>}NETNET)

       

      The next thing I need to get is get a forward booked position. If I choose a BOOKINGDATE this year what were the bookings at the same time last year?

       

      I have no idea where to start with this one.......

       

      Thanks in advanced