Discussions

 View Only
  • 1.  Creating 'status' based on numeric number

    Posted 03-13-2023 16:41

    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.  RE: Creating 'status' based on numeric number

    Posted 03-13-2023 17:57

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



  • 3.  RE: Creating 'status' based on numeric number

    Posted 03-13-2023 18:04

    Worked - thanks so much!



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