Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Current Load Statement is working properly,
if([Incident Related to Interaction Flag]='y',if([Incident Opened by Email Name]='HPOO','User'))as [User or Non-User Generated2]
but I need to add another search value to the [Incident Opened by Email Name] part of it and I cannot get it to work.
I need it to check if:
[Incident Opened by Email Name] = 'HPOO' OR '*@*'(any email address)
[Incident Related to Interaction Flag]= 'y'
Output= 'User'
Thanks!
Dan
May be this:
If([Incident Related to Interaction Flag]='y',
If(WildMatch([Incident Opened by Email Name], 'HPOO', '*@*'), 'User')) as [User or Non-User Generated2]
Thank you Sunny T- that worked!