MichaelStromber
2 years agoQrew Member
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 totals are already pulled), assign a status from below.
Champion | 8+ |
Avid | 6-7 |
Average | 3-5 |
At Risk | 1-2 |
Lapsed | 0 |
------------------------------
Michael Stromberg
------------------------------