Skip to main content
Topics#Ask An ExpertVinitha Subramanya의 질문
Vinitha Subramanya (Myriad Genetics) 님이 #Ask An Expert에 질문했습니다
2021년 1월 25일 오후 11: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일 오후 1: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