The solution section provides an overview of how to solve this scenario, and why that solution was chosen. The Solution Steps section immediately following outlines the exact steps used to replicate the solution.
Solution:
To view the remainder of this content, you must purchase the Salesforce.com Certified Administrator Study Guide. Please Login or purchase the study guide.
Hi John!
First off, I have to say hats off to ya for making such a comprehensive guide here!
As for the above exercise, I’m a bit confused with your solution.
Originally I used the ‘Count’ function on stage = Closed Won, which produced the correct result. However when I switched to ‘sum’ of ‘amount’, with stage or switching to won = True, I get what I would expect, the total revenue of all the related opportunities that have been won. Am I missing something here?
Thanks, Cheers
Oh nevermind John, I just realized my mistake was how I interpreted the question. I thought the amount of sales was how many deals, not the amount of money, lol. Another great point to remember on the test, read very very carefully! 😛
Cheers
This is neither a master-detail nor a lookup relationship, I see.
hi john,
I also want to know for roll up summary that how many more standard objects can we couple to-gather , why account and opportunity only mentioned here…there are more standard objects…but as new learner ,how can i get idea that i don’t need master detail on here,:(
understood this scenario after having mostly same kind of doubts as others have … but getting in to fear that what else could b more hidden or i m missing in here.
if some more related standard objects are possible, like this unique way , can you please list out them…just for a reference. some exceptional case.
I don’t know of any documented source for that information but have shared what I know on this page: http://classic.certifiedondemand.com/lookup-or-master-detail-relationship-in-salesforce
It was un clear what sales were to be summarized in the problem description. It was vague. I did lifetime sales and by default got it right. So say something like total sales won for the lifetime of the account.
Thanks Phil – I will add some language there
Added the word “lifetime” – the success criteria is pretty specific though…
Hi John,
At step 5, for odd reason I can’t see “Amount field”. There are other fields but not amount. What can be the reason for that?
Select Summarized Object “Opportunities”.
Select Roll-Up Type “Sum” and Field to Aggregate “Amount”. <>
Thanks
Check that you have access to the field (via field level security) and that you haven’t renamed the field… and that you are logged in as a system administrator.
Will post if I can think of anything else… odd.
The other possibility is, you have to scroll UP inside the box. I did.
Hi John,
I am having this same problem. I can’t see ‘Amount’ in the picklist. I am logged in as System Admin and FLS is ‘Editable’. Did you ever figure out what was happening?
Thanks!
Dona
Hi Dona,
Are you creating the rollup summary field on the account object? When you create the field, your screen should mirror the sreenshot in the steps above.
Okay, to do the Scenarios I have been using my free 30 day trial org that I used for the Admin 201 class. For some reason I could not see the Amount field. I just ordered up a new training org and tried it and the Amount field is there! So I’m not sure what happened to it in the “used” org. Some exercise we did? It doesn’t really matter. I’m just glad I was finally able to get the Scenario completed.
That’s really weird. You might check the limits section for that object- maybe the rollup summary fields were already used?
Hi,
Can you give us a bit more information on the field “won”?
Get into Setup–>Customize–>Opportunity, do not see this field “won”. Where is this field defined?
How does this field get set to True/False?
Thanks.
Iswon and Isclosed are derived from the opportunity stage. This links should help:
https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_opportunity.htm
https://success.salesforce.com/answers?id=90630000000goUZAAY
How is this selection of “Summarized Object” determined. In this case the Master object is Accounts and the only Summarized object available is “Opportunities”.. Any other objects cannot be selected as a “Summarized Object’? where do we set this up ?
Objects can be summarized if they have a master-detail relationship to the parent object (e.g. add a master-detail field from venue custom object to account – this will allow you to summarize on the venue object), or a specific standard lookup relationships (e.g. opportunity to account is a lookup, but is a ‘special’ lookup that allows summarization).
I think what Anand was asking (and what I would like to know as well) is whether there are any other “special” relationships among the standard objects which would all RSF creation?
I have never seen a documented list of this nature – the two I know of are Opp –> Account and Opp Product (opportunity line item) –> Opportunity
I am confused about RSFs. In this scenario, we use a RSF to establish a relationship between Accounts and Opportunities. Elsewhere, you state that only Master-Detail relationships can support RSFs, and that Standard Objects cannot be the detail side of a relationship. But both Accounts and Opportunities are standard. Is there an exception due to the tight coupling of Accounts with Opportunities?
I must be missing something very fundamental about RSFs and Master-Detail.
Correct – good point Grant. A RSF will work with some standard relationships that are not M/D, but will require M/D to work within a custom relationship.
You’ll notice that Account/Opp works, but Account/Contact does not, for example.
@JohnCoppedge,
I’ve gone an extra mile and tried setting up a separate Roll-up Summary field that aggregates current Quarter’s Sales total, leveraging the similar idea used for the Scenario you introduced.
In doing this, I tried to use the dynamic date value (i.e. This Quarter, This Year, etc that were introduced in creating List Views topic) on the Closed Date field. However, it seems that the dynamic date value is not supported in the context of creating a Roll-Up Summary field.
Can you advise how this can be achieved, if possible?
K
I don’t believe that you can reuse those list view / report dynamic filters in the context of formulas, unfortunately. I’ve tried to do something similar many times as well!
Salesforce help kinda mentions almost this particular scenarion https://help.salesforce.com/HTViewHelpDoc?id=fields_about_roll_up_summary_fields.htm&language=en_US (look at the very bottom)
🙁
What you could do is write a formula field on the object you’re rolling up – e.g. on the opportunity.
Boolean formula for IsThisQuarter and then set the rollup to only include when true.
Hi John
Formula also works if Stage = Closed/Won.
Regards
Sue
Yep very true – if you have more than one closed/won stage then you would want to adjust accordingly!
Thanks Sue