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