locked
Risks and Issues Rag Scores RRS feed

  • Question

  • 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

  • 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

  • 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
  • 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
  • Thanks Kashif
    Sunday, February 26, 2012 9:25 PM
  • Thanks Brian
    Sunday, February 26, 2012 9:25 PM