I have a list of 17,000 customer codes which all belong to one of 20 or so representatives. I am building a report that would break down by salesperson, what shipped out the previous day. Problem is the tables contain no salesperson information.
What I need to do is create a formula based on the customer number, but I'm not sure how to do this.
Basically I need it to be something like....
IF {SHIPHIST.CUST_NUM} = 1,2,3,4,5,6,7,8,9,10 OR 11 THEN "Salesperson 1"
ELSE IF {SHIPHIST.CUST_NUM} = 12,13,14,15,16 OR 17 THEN "Salesperson 2"
ELSE "Salesperson 3"
Is this possible?