Skip to main content
Topics#Data ManagementKris Webster의 질문
Kris Webster 님이 #Data Management에 질문했습니다
2019년 1월 3일 오후 3:57

BLANKVALUE with PICKVAL Criteria

I need to write a formula for a formula field that will do the following: 

 

If the Billing Event Category (pse__Category__c) is "Expense," then the formula field will fill with Billing Net Value (pse__Expense__r.Billing_Net_Value__c) and if billing net value is blank then it will fill with Billable Amount (pse__Expense__r.pse__Billable_Amount__c). 

 

The next criteria for this formula is that if the Billing event Category (pse__Category__c) is "Timecard" then the field will fill with Total Billable Amount (pse__Total_Billable_Amount__c) 

 

I know this is sorta complicated but I need to figure it out! Any help would be greatly apopreciated. 

 

Here is what I have so far.. 

 

 

AND(
ISPICKVAL( pse__Category__c, "Expense"),
BLANKVALUE(pse__Expense__r.Billing_Net_Value__c,pse__Expense__r.pse__Billable_Amount__c))
||
ISPICKVAL( pse__Category__c, "Timecard"), 
pse__Total_Billable_Amount__c)

 

 
답변 5개
  1. Micah Perry (TruSummit Solutions, LLC.)
    2019년 1월 3일 오후 4:11
    Messed up again.

     

     

    IF(
      ISPICKVAL( pse__Category__c, "Expense") &&
      ISBLANK(pse__Expense__r.Billing_Net_Value__c), pse__Expense__r.pse__Billable_Amount__c,
      IF(
        ISPICKVAL( pse__Category__c, "Expense") &&
        NOT(ISBLANK(pse__Expense__r.Billing_Net_Value__c)), pse__Expense__r.Billing_Net_Value__c,
        IF(ISPICKVAL( pse__Category__c, "Timecard"), pse__Total_Billable_Amount__c, 0.00)
      )
    )

     

     
답변을 작성하세요...
0/9000