Forum Discussion
Solved
Create Category Values Based on Another Column Range
I've search the forums and can't find an issue quite like this...but it should be simple. I simply want to create a "range" column based on a number in another column, in the same way I would a CASE...
You can try this as a new column:
new column =
IF(calculate(count(t1.CUST_NAME)) = 1 , "1 Truck",
IF(calculate(count(t1.CUST_NAME)) = 2 , " 2 Trucks",
IF(calculate(count(t1.CUST_NAME)) = 3 , " 3 Trucks",
IF(AND(calculate(count(t1.CUST_NAME)) <= 6, calculate(count(t1.CUST_NAME)) <=10, “6 to 10 Trucks”,"Over 1000 Trucks")))
Thanks! Works wonderfully!
