Set Expression comparing to fields (inequality)

[#1]

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])

[danielrozental]

That can't be achieved using set analysis, you can try something like this

Count(
if([itin_trip_days] = >[HOTEL.los],
[HOTEL.hot_itin])
)

[#3 · Accepted solution]

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])
)