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.

       

      Thanks

      Barry