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

  • 2012年4月27日 13:46
     
     
    登入以投票
    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

     

所有回覆

  • 2012年4月27日 15:22
    版主
     
     已答覆
    登入以投票
    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,