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

# 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

• ###### Re: Formula Question / Help

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?

• ###### Re: Formula Question / Help

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

• ###### Re: Formula Question / Help

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;

• ###### Re: Formula Question / Help

Thank you so much Mike.

This is a huge help.