Skip to main content
Topics#Data ManagementKris Webster 的问题
Kris Webster 提问于 #Data Management
2018年12月21日 15:05

Formula HELP

I need to write a formula that will fill a field with the value found in "Billing Net Value" (pse__Expense__r.Billing_Net_Value__c) and if Billing Net Value is NULL then I need the field to fill with BIlling Amount (pse__Expense__r.pse__Billable_Amount__c ) 

 

I am really stuck on the formula so far so I know this is completely wrong, but here is what I have so far 

 

AND(

 

pse__Expense__r.Billing_Net_Value__c,

 

NOT(ISBLANK(pse__Expense__r.Billing_Net_Value__c)

 

pse__Expense__r.pse__Billable_Amount__c ))

 

Any help would be greatly appreciated!  
4 个回答
  1. Sunil Sarilla (M&G Investments)
    2018年12月21日 15:16
    Hi Kris,

     

    Please try the below

    BLANKVALUE((pse__Expense__r.Billing_Net_Value__c,pse__Expense__r.pse__Billable_Amount__c)

     

    Importantly, please treat blank values as blanks under blankvalue handling section on the formula field
撰写回答...
0/9000