Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Getting a calculated value using six other boolean custom fields

Answered Getting a calculated value using six other boolean custom fields

  • Friday, April 27, 2012 1:46 PM
     
     
    Sign In to Vote
    0

    Hello,

    I am trying to create a calculated field that will equal 1-6 depending on Yes/No boolean answers in other fields.

    Essentially, I am trying to create a probability prediction for our demand management.  I have six criteria that are yes or no answers.  I want to total the number of yes answers into one "Probability Rating" field.

    I am unfamiliar with the formula to use.  Any help will be greatly appreciated.

    Thanks,

    Matt

     

All Replies

  • Friday, April 27, 2012 3:22 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Matt,

    Simply tried it and when used in a sum apparently in Project 2010 Flag fields are converted to 0 (for No) or -1 (for Yes)

    So your formula (in a number field) could be -([Flag1]+[Flag2]+[Flag3]+[Flag4]+[Flag5]+[Flag6])

    Greetings,