Hi there,

I have two conditions that I want to fulfil in filtering the data. I the forst case, the field {vwTMActualPersonnel.PersonnelRoleCode} may or may not have entries for "LEADS", and if not, I want the report to look at entries for "SURG" as a fall back. The "LEDEN" field is spearate and not related.

The formula I come up with is as follows:

{vwSPActualSession.StartDate} in Last7Days and
(
if {vwTMActualPersonnel.PersonnelRoleCode} = "LEDEN"
then {vwTMActualProcedure.MainProcedure}
OR

if {vwTMActualPersonnel.PersonnelRoleCode} = "LEADS"
then {vwTMActualProcedure.MainProcedure}

OR

if {vwTMActualPersonnel.PersonnelRoleCode} = "SURG"
then {vwTMActualProcedure.MainProcedure})

If I use OR statements, then I only get the first selected field value. If I use ELSE I get everything. What I need a filter for the "LEADS" and "SURG" values, and also include the "LEDEN" values.

Thanks!