تسجيل الدخول
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Getting a calculated value using six other boolean custom fields

已答覆 Getting a calculated value using six other boolean custom fields

  • 06/جمادى الثانية/1433 01: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

     

جميع الردود

  • 06/جمادى الثانية/1433 03: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,

    • تم الاقتراح كإجابة بواسطة Andrew Simpson 09/جمادى الثانية/1433 01:59 م
    • تم وضع علامة كإجابة بواسطة Barbara HenhaplMVP, Moderator 18/محرم/1434 12:44 م
    •