Why does my Alert pop-up not apear?

[#1]

I have setup an alert, which does not seem to work.

In the condition field I have the following:

=if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00',1,'')

This does not work.

I know I have at least one row which matches this value, because I also created a list box with this expression.

When I enter '1' in the condition field, it does show the alert.

Thanks in advance.

Erik

[erichshiino]

You said that you have at least one line that matches, but with this expressions you could have only one value for ArrivalTimeLeft.

You can try to change it to a count:

if( count ( if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00', ArrivalTimeLeft)> 1, 1,0)

Then, if it works, you can try to write in as set analysis to get a better performance.

if( count( {<ArrivalTimeLeft = {">'00:00:00' <'01:00:00' " }>} ArrivalTimeLeft )>1, 1,0)

Hope this helps,

Erich

[#3 · Accepted solution]

Thanks for your help.

The below was the solution for my issue.

=count ( if(ArrivalTimeLeft>'00:00:00' and ArrivalTimeLeft < '01:00:00',1,'')>0)