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

Con risposta Getting a calculated value using six other boolean custom fields

  • venerdì 27 aprile 2012 13:46
     
     
    Registrati per votare
    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

     

Tutte le risposte

  • venerdì 27 aprile 2012 15:22
    Moderatore
     
     Con risposta
    Registrati per votare
    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,