Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    88
    Provided Answers: 1

    Answered: Help Needed: Points and Ranks

    Hello Guys,
    Please I need help with this. I’m trying to get ranks for sales people based on points created from sales. I’ve actually tried but find it challenging. These are the points and respective ranks

    100 – 1999 = Sales Agent
    2000 – 4999 = Snr. Sales Agent
    5000 – 14999 = Deputy Principal Agent
    15000 – 29999 = Principal Agent
    30000 – 59999 = Deputy Superintendent
    60000 – 149999 = superintendent
    150000 – 249999 = Deputy Chief
    250000 – 399999 = Chief
    400000 above = Crown Chief

    (the least sales point that can be generated is 100)

    Thank you… please find db attached. Sales Rank.zip
    Evans

  2. Best Answer
    Posted by MacHeuS

    "if-else if-endif

    Attachment 17097"


  3. #2
    Join Date
    Jul 2012
    Posts
    94
    Provided Answers: 4
    if-else if-endif

    Sales Rank - MacH01.zip
    I do not know English well. I am using Google Translate for translation. Please do not laugh my sentences.

  4. #3
    Join Date
    Oct 2014
    Posts
    88
    Provided Answers: 1
    Thanks a lot MacHeuS for the urgent response. The mistake I was making was using a "single-line text field" for the points generated instead of a "Numerical field"... I saw that you changed the field. Thank you. I'm grateful

    Evans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •