Creating 'status' based on numeric number
I am trying to create a status column, based on a numeric field "Total number of sales'.
We have 5 different catogires, within last 30 day. Try to based on total number of sales field (last 30 day ...
Forum Discussion
A case formula should work
Case(true,[your sales field] > 7,"Champion",[your sales field] > 5,"Avid",[your sales field] > 3,"Average",[your sales field] > 0,"At Risk","Lapsed")
------------------------------
Simon H
------------------------------
Worked - thanks so much!
------------------------------
Michael Stromberg
------------------------------
