4 Replies Latest reply on Jun 11, 2016 7:48 AM by Manideep Bhattacharyya

    Hotel Booking Cancellation

    Shariq Mohd

      Hi All I have a table the data structure of which is like in the attached excel file. The data look something like this.


      Problem : The Client want to know all customer who cancelled their booking in 24 hours and booked another hotel.


      The customer must have cancelled the booking because he must have got a cheaper and better deal.


      What calculation formula can we use to create a calculated field which can help me achieve this or is there any other way i can take to achieve this.



      Please note that the data set doesn't have the cancellation date/time stamp.



      Manideep Bhattacharyya Pooja Gandhi Shawn Wallwork Vinoth kumar Balakrishnan Sankarmagesh Rajan Louis Archer Charlie Archer Tim Archer


      Rohan Malusare