You need to sign in to do that
Don't have an account?
Datajunkie
Need formula that will multiply a field in a related list with a field in the parent
Long story shortened...
Our Opportunities are often shared sales with other reps. The Sales Team related list is nice to capture who they are, but that's all it can do. I need to capture not only who they are, but what percent of the sale they get credit for, what that equates to in terms of "volume credit", the commission amount paid to each, and the date paid.
The end product will simply be a report that shows the total dollars sold for each rep - which will sometimes include a partial credit sale. Example:
Jane Smith sold one Opp by herself, for $100 (is listed as the owner of the Opp)
John Doe sold one Opp by himself, for $200 (is listed as the owner of the Opp)
Jane and John cooperated on another Opp, for $100. Jane is the owner of the Opp, and for this sale, she should receive 75% credit, with John to get 25%
The report needs to show:
Jane Smith $175
John Doe $225
Sounds really simple, but is driving me up the wall.
I tried creating multiple fields on the Opportunity object, which worked just fine. The data entry would be easy, and the display of information very easy to understand. But then I can't report on it in a useful way, because I can't combine the Amount field with the two Shared Volume fields I created, and match up the rep at the same time. I think the right thing to do is to have a related list, similar to that Sales Team list, but with more fields.
I created a custom object - Shared_Sales, with a master-detail relationship to Opportunity. Then I created the fields for Rep, Percent Credit, Commission Paid, and Commission Date. But the "Volume Credit" field should be a calculation of the Opportunity Amount times the Percent Credit (my custom field in the custom object). I can't seem to make the formula "reach back" to the Opportunity record to capture the Amount.
I made an S-Control which can do it, but I can't make that S Control show up in the related list on the Opportunity page. Having just the name and percent is good, but they're going to want to see the exact $ volume that they'll receive credit for.
That's not even to mention the problem of trying to figure out how to populate the related list with a default record if there are no additional reps. (i.e. - the Owner needs to get 100% credit if there is no one else involved, so I can report on the "Volume Credit" field as a whole).
If I'm totally barking up the wrong tree, please tell me! This seems like such a simple function, and management is absolutely adamant that we *must* be able to do this. I've already spent 2 days on this, and I'm no closer to a solution than when I started.
HELP!
Also, if you haven't already, check out the idea for providing the ability to split opportunities natively --
http://ideas.salesforce.com/article/show/41050.
Kristin