2 Replies Latest reply: Jan 29, 2013 2:54 PM by Daniel Taylor RSS

    PICK ( WILDMATCH (  Dimension Question

      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')