Selection

I an trying to create a condition when a any single record in a "set" records returns the condition.

For example I am using:

If {Table.EVENT} startswith "+SLA" then stringvar event := "+SLA" else stringvar event := "Does not contain +SLA"

The issue I have is it returns the answer based on the most recent record in the group, so for the data below it returns "Does not contain +SLA".

I am looking for a query that says if any of the record contain "+SLA" then stringvar event := "+SLA" else stringvar event := "Does not contain +SLA"



Table.EventTD        Table.Event
03/03/2017 08:18:40   LOC changed               
03/03/2017 08:18:40   Task Signed to History           
03/03/2017 08:18:26   +SLA Resource issue
25/02/2017 02:56:01   Creation of helpdesk task          
25/02/2017 02:56:01   New Breakdown Issued     

Any suggestions or advice?

Kind regards,

Iain.

do you have an event ID or something that is defining these rows as a single 'group' which are trying to apply this rule to?
IF so group on that, create a formula that identifies the value you want for the group
If {Table.EVENT} startswith "+SLA" then 1 else 0
sum this formula for the group
use the group sum for your our put
if sum(formula,group)>0 then "+SLA" else "Does not contain +SLA"

DBlank,

Thank you for taking the time to reply. I really appreciate you helping out a stranger. I'll give this a go.

Kind regards,

Iain.