[QuizIntro]
[RCNotLoggedInNotAdmin]
[/RCNotLoggedInNotAdmin]
[RCAdmin]
[WpProQuiz 15]
[/RCAdmin]
The best exam prep on the planet
[QuizIntro]
[RCNotLoggedInNotAdmin]
[/RCNotLoggedInNotAdmin]
[RCAdmin]
[WpProQuiz 15]
[/RCAdmin]
You must be logged in to post a comment.
Hi John, Formula is always created on child object. In question 2 we are creating formula on campaign which means it is a child object. But we can’t use standard object on the child side. How this is going to work.
The relationship from Campaign to Venue would have to be a lookup relationship (rather than m/d)- therefore the relationship could be created on the campaign object.
Hi John,
Why can’t we create a roll-up summary field on opportunity to aggregate the lifetime sales of the account (Question 3).
Thanks!
The field has been created… you need to display that field on the opp
Hi john,
Also, isn’t it that Roll-up Summary fields work downwards? That is, Parent to Child? Meaning we couldn’t perform a Roll-up on the Opportunities since they are the Children of Accounts?
Yep- so the rollup field has been created on the account and is in place already. What this question is asking is – how would you display that account data on the opportunity. The field type of the data on the account is actually not important – it’s the replication of the information on the opp.
can we add a roll-up summary field on account record to display all closed-won opportunity related to the particular account?Is it a M-D relationship? plz clarify…
Yes you can summarize opportunity data on the account using roll up summaries. To use a rollup field with a non-standard relationship you need a master/detail relationship between the objects.
thank you John..
Where is a list of the “valid formula functions”? I don’t even see the lastmodifieddate as an available option. YES, I know what is listed is not an exhaustive list. However, if there are questions such as this I would like to be familiar with the most common options.
Here you go: https://help.salesforce.com/HTViewHelpDoc?id=customize_functions.htm&language=en_US
Note that lastmodifieddate is a FIELD not a formula function. You would need to compare that field data using some sort of formula function.
Hi,
Quick question, how much formula syntax should we learn or expected to know for this test?
Very good question- although I don’t know an exact answer to it unfortunately.
I would suggest the following:
Study the syntax of formula itself (e.g. be able to identify a formula that is missing a parenthesis or missing quotations, etc.)
Study the different types of functions available
Know how to implement the more common examples (e.g. cross object to display info, simple formulas using IF AND OR CASE, etc.)
Can a cross object formula reference a rollup summary field..Isn’t a limitation?
sorry, my bad…its the other way around.You can’t reference cross-object formulas in roll-up summary fields.
Correct – you can probably do some sort of workaround for that now with process builder. But a good limitation to know about for sure.
Thanks, John! I just implemented your question 3 into my actual SF environment! lol
Nice!
A roll-up summary field called “Lifetime Sales” has been added to the account object and displays the total of all closed/won opportunities associated with an account.
Isn’t opportunity a standard object?
Is it possible to create a A roll-up summary field that reference it?
Yes- and yes (on account only)
yeah 100% on this one too. woot!
🙂
I think there might be a typo in the first question: “(…) to display the date 7 after today’s date?”
Perhaps it should state “to display the date 7 *days* after today’s date?” (otherwise, it sounds like you are asking about the 7th day of the following month)
Thanks Roger – updated.
hi John.
Please let me know the procedure to purchase Admin guide..
Thanks,
Sai
Hi Sai – you can sign up here: http://beta.certifiedondemand.com/register/certified-administrator-study-guide/
Hi Brian,
The syntax within a cross-object formula uses __r when referencing a relationship through a custom field (instead of __c). The actual API name of the field is still includes __c, however (it is just when referenced in relationships that it changes to __r). If you create a formula referencing a cross-object formula, you can see this in action. I can understand how this would be confusing – I’ll look at rewording the question.
Cheers,
John
Bump
The syntax refers to Venue__r and the question refers to Venue__c