Skip to main content
Topics#Ask An ExpertVinitha Subramanya の質問
Vinitha Subramanya (Myriad Genetics) が「#Ask An Expert」で質問
2021年1月25日 23:10

how to use opportunity line item in custom formula field

Hi All,

 

I am trying to create a formula field for our custom Docusign fields object that would ideally pull the Product line item total price based on the product code. However, the only option I get for insert fields are the Opportunity and Opportunity Product objects. How can I relate the Opporunity line item to this object?

 

The formula I hope to use is

 

transition cost=

 

IF(ProductCode='TR',[OpportunityLineItem].TotalPrice*6,0)

 

This formula would pull in the word document in our T&C

 

Transitions costs at a total cost of <<DOCUSIGN_FIELDS_ITT_Cost>>   

 

Appreciate any assistnace on this regards,

 

Thanks,

 

Vinitha

 

 
3 件の回答
  1. Vinitha Subramanya (Myriad Genetics)
    2021年1月26日 13:52
    Thanks Ankush. So ideally, my below formula should pull the line item total price for the said product, right?

     

    Transition Cost=

     

    IF(ProductCode='TR',TotalPrice*6,0)

     

    I&T Cost=

     

    IF(ProductCode='I&T',TotalPrice*6,0)
回答を記入...
0/9000