Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV Community,
I am making a pivot table that will show total email vs total mail. I have a field labeled FName which has the location name and type of communication so I need to search the whole text for just 'mail' or 'email', and I need to just show email and mail. When I use the below expression, the figures are correct and it shows the label Email, but not the label Mail (it shows a dash ' - ' ). How can I adjust this to show both Email and Mail?
=
PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*') ,'Email','Mail')
If wildmatch doesn't match anything it will return 0. And you specified only one match pattern. Pick starts at 1, so feeding pick a 0 won't give a result. So try this:
PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*')+1 ,'Mail','Email')
If wildmatch doesn't match anything it will return 0. And you specified only one match pattern. Pick starts at 1, so feeding pick a 0 won't give a result. So try this:
PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*')+1 ,'Mail','Email')
Perfect, thank you for the correction and explanation.