Forum Discussion

MichaelStromber's avatar
MichaelStromber
Qrew Member
2 years ago

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
------------------------------

2 Replies

Sort By
  • SimonH's avatar
    SimonH
    Qrew Cadet
    2 years ago

    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
    ------------------------------
    • MichaelStromber's avatar
      MichaelStromber
      Qrew Member
      2 years ago

      Worked - thanks so much!



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