0 Replies Latest reply on May 28, 2013 10:26 AM by Kent Vo

    Filter contains does not work

    Kent Vo

      I have a workbook contains 3 columns (custID, DOP, and Total). I have a filter promotion code and set to wildcard with option "Contains". But when enter the promotion code as "123", the Total (sum) come out incorrectly. Total doesn't include any record with promotion code has something like "123456", "456123", "345123234". It only returns records only have promotion code equals to "123" alone. Am I missing something here? Please help.