I'm trying to do the following:
1 - pull in only three types of SERVICES
2 - query against those three SERVICES to check
if SERVICE is either 'serviceA' or 'serviceB' then
display only those records where REFERRED_TO REFERRED_FROM
else display the record regardless end
I've been trying to get this since yesterday without luck.
Query1].[Service] in ( 'Lending Pipeline (Referrals)', 'Deposit Pipeline (Referrals)', 'Third Party Services (Referrals)')
filters the three services I need but after that I'm not making any progress. I've tried nested IF statements and CASE statements but I'm missing something in the syntax I guess.
Any help greatly appreciated.