Formula Question / Help

[#1]

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

[m_woolf]

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?

[#3]

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

[m_woolf]

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;

[#5]

Thank you so much Mike.

This is a huge help.