QUE 1 :

       I have created a Reservation system in zoho creator.I have a field lke this Cmpany Name,Guest Name, Room Name, Room No, Check in date,Check out date,

...etc. I want to calculate nights between check in and check out dates and also calculate Occupancy % for each room .Please find solution for this question, this is very help to me.

QUE 2:

      How to count a records for each report  for ex: I hav created a report like this

      i. Current Booking(10)

      ii. Past Bookings(20)

      iii.Cancelled Bookings (5)

Now i want to show how many records for each reports in header

QUE 3:

       Next my que is i want check availablity for dates

ex: Now i am gng to enter check in and check out dates but that dates already booked ,so i want to show (No  availablity on this days)

 How to connect two reports for this operation

Please send answer