Calculate
Hi Dears, Can someone help me please to do a calculation for total staying in accommodation based on movement type (check-in/check-out) and consider the other filter like per user number and per requester of movement type - The logic will be: Total_Stay = (date and time for check out) - (date and time for check in) per User and per requester below is an example of the data: date and time Date User Accommodation Movement type Requester 9/23/2021 16:12 9/23/2021 User 1 ACC1 Check-In Requester 1 9/25/2021 16:53 9/25/2021 User 1 ACC1 Check-Out Requester 1 9/23/2021 16:12 9/23/2021 User 2 ACC1 Check-In Requester 3 9/25/2021 16:53 9/25/2021 User 2 ACC1 Check-Out Requester 3 Thanks and looking forward for your support.
