Skip to main content
Topics#Data ManagementEric Vitucci 的问题
Eric Vitucci (EMS by DEA) 提问于 #Data Management
2015年12月1日 17:14

Building another percentage complete formula but I am not getting the correct numbers.

Here is the formula I am using when I add just one person I am getting a value of 400% which is clearly wrong. Not sure if it makes a difference but the fields that are being used in the formula are forumula fields that are pulling a value from a lookup field. I think that could be the problem not sure of the way around it. When I tried to use Lookup fields Salesforce limited me to only 8 in the formula and the value was showing 100% when I only had one filled out. Any help would be great!

 

IF(ISBLANK(Business_Owner_I__c ),0,1)+

 

IF(ISBLANK(BusinessApprover__c),0,1)+

 

IF(ISBLANK(BusTotalMgt__c ),0,1)+

 

IF(ISBLANK(Technology_Approver__c),0,1)+

 

IF(ISBLANK(Technical_Decision_Maker__c),0,1)+

 

IF(ISBLANK(Technical_Decision_Maker__c),0,1)+

 

IF(ISBLANK(FinanceApprover__c),0,1)+

 

IF(ISBLANK(Finance_Owner__c),0,1)+

 

IF(ISBLANK(Financial_Decision_Maker__c ),0,1)

 

/9
6 个回答
  1. Brian Makas (N/A)
    2015年12月1日 17:28
    This might just be an order of operations issue (divide happens before add) ... before I overthink this could you let me know if this works?

     

    (

     

    IF(ISBLANK(Business_Owner_I__c ),0,1)+

     

    IF(ISBLANK(BusinessApprover__c),0,1)+

     

    IF(ISBLANK(BusTotalMgt__c ),0,1)+

     

    IF(ISBLANK(Technology_Approver__c),0,1)+

     

    IF(ISBLANK(Technical_Decision_Maker__c),0,1)+

     

    IF(ISBLANK(Technical_Decision_Maker__c),0,1)+

     

    IF(ISBLANK(FinanceApprover__c),0,1)+

     

    IF(ISBLANK(Finance_Owner__c),0,1)+

     

    IF(ISBLANK(Financial_Decision_Maker__c ),0,1)

     

    )

     

    /9
撰写回答...
0/9000