Creating 'status' based on numeric number

Question

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.&nbsp;

&lt;!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--&gt;

Champion
8+

Avid
6-7

Average
3-5

At Risk
1-2

Lapsed
0

------------------------------Michael Stromberg------------------------------

simonh · Answer

A case formula should work

Case(true,[your sales field] &gt; 7,"Champion",[your sales field] &gt; 5,"Avid",[your sales field] &gt; 3,"Average",[your sales field] &gt; 0,"At Risk","Lapsed")------------------------------Simon H------------------------------

michaelstromber · Answer

Worked - thanks so much!------------------------------Michael Stromberg------------------------------

Forum Discussion

Creating 'status' based on numeric number