If statement error

[#1]

I have created scripting error where my statement is IF(EvType= 15 AND EvParam1 > Lookup('SystemResponseTime','%MailBoxID',EvMailBoxID,'MailBox'), 'Not met Service Level', 'Met Service Level' ) AS ServiceEventLevelStatus, well you can imagine the part not Met Service level is correct however, For met service level I only want it so that IF(EvType= 15 AND EvParam1

[#2]

I need it to be a field,  where the end user can choose if it has met or not, maybe a link key can work where I link
evtype, evparam1 and evparam2  ?

[Greg_Williams]

A list box can be created (from scratch)...and you can put in your own expression. Worth a try.

[#4]

What would my expression be?

[#5]

My apologizes I have never created a listbox embedded to an expression.

[Greg_Williams]

New Sheet Object > List Box... > Field > <Expression> > test logic to determine if this is working as expected > this will be able to provide choices that can be used to filter data elements.

[#7]

I have tried the expression but receiving nothing

=IF(EvType= 15 AND EvParam1 > SystemResponseTime, 'Not met Service Level') OR IF(EvType= 15 AND EvParam1 <= SystemResponseTime, '

Is my OR if statement negating everything?

[Greg_Williams]

Without having a look at the data, the thing that concerns me is EvParam1 > SystemResponseTime (because sometimes - dates are not sometimes straight-forward...might require date(<date>,'MM-DD-YYYY') in logic. ...something like that. Have you tested one logic piece at a time to see if it works alone? Then we can stack the logic.

[#9]

@evtype 15 the evparam1 is a number in seconds, and so is SystemResponseTime,  My apologies for not clarifying that

[#10]

I think it requires a nested if statement but I am not sure what to use

[Greg_Williams]

You can floor(<date>) to strip away the time > makes it easier to work with dates.