See attached qvw. Note, the inline load is just an example. Substitute it with something that loads your actual data. But why you do have two days for group BBB when the difference between checkindate and checkoutdate is only one day? If it's not a mistake you'll have to explain the logic.
See attached qvw. Note, the inline load is just an example. Substitute it with something that loads your actual data. But why you do have two days for group BBB when the difference between checkindate and checkoutdate is only one day? If it's not a mistake you'll have to explain the logic.
You could use peek function while loading. IF PEEK(Name)=Name then Date=(Checkindate+1) else checkindate.The date syntax is not exact, you have to use combination of floor and date.
