4 Replies Latest reply: May 21, 2015 3:25 PM by Barry Taylor RSS

    Formula Question / Help

      Good Afternoon,


      I am looking to visualize data and assign a score of sorts to that data.


      For example,


      IF field "SAGMDOL" is between 0 and 500 = 1, if it is between 501 - 1000 = 2, and if it is >1500 = 3


      I want to use this scoring so that I can identify accounts that are at high risk of costing our organization money if we take a low margin deal.