Answered by:
Risks and Issues Rag Scores

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
- Proposed as answer by Brian Kennemer, MVP Friday, February 24, 2012 5:25 PM
- Marked as answer by Brian Kennemer, MVP Monday, February 27, 2012 12:05 AM
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
- Proposed as answer by Brian Kennemer, MVP Friday, February 24, 2012 5:25 PM
- Marked as answer by Brian Kennemer, MVP Monday, February 27, 2012 12:05 AM
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 | LinkedInFriday, February 24, 2012 5:26 PM -
Thanks KashifSunday, February 26, 2012 9:25 PM
-
Thanks BrianSunday, February 26, 2012 9:25 PM