Skip to main content
Topics#Data ManagementRose Farnham's Question
Rose Farnham (Big Dog Computing) asked in #Data Management
May 13, 2016, 6:05 PM

How to create a formual fields for Opportunity Products to multiply Units per Week by Number of Weeks?

I am working Opportunity Products and I have a field called Units Per Week (Number field) and a fields called Number of Weeks (Number field).  I want to multiply the two fields together to get he Total Units.  I have created the Total Units field: Number formula field - Units_per_Week__c * Number_of_Weeks__c.  This all seems correct but when I place it on the Opportunity Product Related List is it 0.  When it should have a value in it.  I then want to take the Total Units and multiply it by the Sale Price to get the Total Investment.  Total Investment is a formula field UnitPrice *Total_Units__c.  Any help on what I am doing wrong would be greatly appreciated.

 

How to create a formual fields for Opportunity Products to multiply Units per Week by Number of Weeks?

 

Thanks,

 

Rose
9 answers
  1. Avinash Vatsya (Davanti Consulting)
    May 14, 2016, 9:59 AM

    No that can not be a issue.

    Untill and unles you are reffering correct field in formula it should give correct output as per fields value.

    In formula try inserting field using insert field button, (may be you are reffering to wrong field).

Write an answer...
0/9000