Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Risks and Issues Rag Scores RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    I am trying to figre out the best way to calculate my companies risk and issue rag scores.  This should be a simple task of Probability * Imapact gives me a score.  However our scoring is slightly different (Stupid) and has 125 different conditions.  I have tried to make use of the calculated field option when you add a colum within the Risk or Issue Section.  However there is a limit on the number of Nested Ifs I can use.  Can any one help please.

    Rob

    Friday, February 24, 2012 6:25 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Rob,

    One way of doing this is by using multiple custom fields with formulas and combining them in to your main custom field which you'll be using.

    Thanks, Kashif

    Friday, February 24, 2012 10:06 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Rob,

    One way of doing this is by using multiple custom fields with formulas and combining them in to your main custom field which you'll be using.

    Thanks, Kashif

    Friday, February 24, 2012 10:06 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Nice. To expand on this...

    This would be a matter of creating some calculated fields that produced the individual conditions or sets of conditions and then in the main field you would just be comparing these field results to get the main result.

    Brian Kennemer – DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    Friday, February 24, 2012 5:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Kashif
    Sunday, February 26, 2012 9:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Brian
    Sunday, February 26, 2012 9:25 PM