Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to count the number of hotel bookings (hot_itin) for a "partial stay," whereby a a customer booked a hotel for an amount of time (HOTEL.los) less than his/her air travel dates (itin_trip_days). I can't figure out what I'm doing wrong and have tried multiple iterations, so any help is greatly appreciated.
The code I'm using is the following:
Count(
{$<
[itin_trip_days] = {$('>[HOTEL.los]')}
>}
[HOTEL.hot_itin])
Thanks Daniel, appreciate the help. It didn't like the version with the equal sign, but I removed the equal sign and the below verson works:
Count(
if([itin_trip_days] > [HOTEL.los],
[HOTEL.hot_itin])
)
That can't be achieved using set analysis, you can try something like this
Count(
if([itin_trip_days] = >[HOTEL.los],
[HOTEL.hot_itin])
)
Thanks Daniel, appreciate the help. It didn't like the version with the equal sign, but I removed the equal sign and the below verson works:
Count(
if([itin_trip_days] > [HOTEL.los],
[HOTEL.hot_itin])
)