I'm trying to create a condition that recognizes when a certain word is anywhere in the iteration of a field. For example..
(dataset1)
Late Fee
Parking ticket
(dataset2)
Admin Charge
Ticket Fee
Parking ticket
(dataset3)
Parking ticket
Admin Charge
Ticket Fee
I want my condition to be true whenever there's and instance of 'Parking ticket' in any iteration within that dataset.
I was thinking the below advanced iteration condition code would work but it only works in dataset3 when 'Parking ticket' is in the first iteration.
=field('fieldname', &CURRENT.LINE)='Parking ticket'
Any help would be appreciated.