Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your logic is flawed, You are not assigning any value for SAGMDOL between 1001 and 1499.
in script:
if(SAGMDOL > 1500, 3,
if(SAGMODL > 1000, "Whatever:,
if(SAGMDOL > 500, 2,1)))
What if SAGMDOL is negative?
Mike,
Thank you for replying. I never thought about the negative factor however after consulting with the powers that be... the complete groupings would be,
SAGMDOL <0 - 0 = 0
SAGMDOL 1 - 500 = 1
SAGMDOL 501 - 1000 = 2
SAGMDOL 1001 - 1500 = 3
SAGMDOL 1501 - 2000 = 4
SAGMDOL > 2001 = 5
in script:
if(SAGMDOL > 2001, 5,
if(SAGMODL > 1500 , 4,
if(SAGMDOL > 1000 , 3,
if(SAGMODL > 500, 2,
if(SAGMDOL > 0, 1,0))))) as Score;
Thank you so much Mike.
This is a huge help.