Delaying (lag) a row value by column date
Dear All,I would like to make a simple calculation but I can not.Attached jmp table is a subset of Hotel Occupancy Data Base.Simple logic for Record ID 27421 is;in 14 Apr 2016 250 Rooms arrive and check in,in 14-15-16 Apr 2016 those 250 Rooms stay at the hotel for 3 days long,in 17.04.2015 the 250 Rooms which arrived in 14 Apr 2016 Check Out (Leave the hotel).I need to calculate the RoomLeave Colu...
saitcopuroglu
jumper
Steven_Moore
sophiaw