You need to sign in to do that
Don't have an account?
Cody Butler
Trailhead Challenge: Admin Intermediate > Formula's & Validations > Using Formula Fields
Is there a known issue with this Challenge or am I doing something wrong?
The Challenge:
Your support team has asked for improved visibility on account activity level at the time they’re helping with customer issues. Specifically, when they’re looking at a case, they’d like to see an at-a-glance view of the number of days since the case’s related account was last active. Create the formula using these requirements.
Setup > Customize > Cases > Fields > Clicked "New" under 'Case Custom Fields & Relationships'
Field Label: Days Since Last Update
Field Name: Days_Since_Last_Update [Why does this field not reflect "Days_Since_Last_Update__c" as is requested in the challenge?]
From the 'Formula Return Type' picklist I selected "Number"
From the 'Decimal Places' picklist I selected "0"
The formula is "Account.LastActivityDate - TODAY ()"
Check Syntax = No errors
Under 'Blank Field Handling' I selected "Treat blank fields as zeroes"
Now when I navigate to a Case Record...the "Days Since Last Update" field is blank.
When I Check the Challenge it says "Challenge Not yet complete... here's what's wrong:
The 'Days_Since_Last_Update__c' formula field did not return the correct number of days between an Account’s Last Activity Date and today"
I cannot figure out what I am doing wrong.
Any guidance?
The Challenge:
Your support team has asked for improved visibility on account activity level at the time they’re helping with customer issues. Specifically, when they’re looking at a case, they’d like to see an at-a-glance view of the number of days since the case’s related account was last active. Create the formula using these requirements.
- The formula should be on the Case object.
- The formula should be of return type Number.
- The formula should be named 'Days Since Last Update' and have a resulting API Name of 'Days_Since_Last_Update__c'.
- The formula should return the number of days between the account’s Last Activity Date and today.
Setup > Customize > Cases > Fields > Clicked "New" under 'Case Custom Fields & Relationships'
Field Label: Days Since Last Update
Field Name: Days_Since_Last_Update [Why does this field not reflect "Days_Since_Last_Update__c" as is requested in the challenge?]
From the 'Formula Return Type' picklist I selected "Number"
From the 'Decimal Places' picklist I selected "0"
The formula is "Account.LastActivityDate - TODAY ()"
Check Syntax = No errors
Under 'Blank Field Handling' I selected "Treat blank fields as zeroes"
Now when I navigate to a Case Record...the "Days Since Last Update" field is blank.
When I Check the Challenge it says "Challenge Not yet complete... here's what's wrong:
The 'Days_Since_Last_Update__c' formula field did not return the correct number of days between an Account’s Last Activity Date and today"
I cannot figure out what I am doing wrong.
Any guidance?
1) https://developer.salesforce.com/forums/?id=906F0000000BSUKIA4
2) https://developer.salesforce.com/forums/?id=906F0000000BQwUIAW
Please create one formula field with Number type on case object like below
Please let us know if this will help you
Thanks
Amit Chaudhary
Your formula returns negative value which is incorrect.
For Example, If Account.LastActivityDate= 5th March, 2016 and TODAY() is 7th March,2016.
It will return (-2).
Just reverse it:
Kind Regards,
Sourav.
Thank you for sharing your knowledge, so I wanted to ask within the trail that contains this challenge an example is given:
Example 2: Displaying the Number of Days Until an Opportunity Closes on a Report a similar. Within this example it gives the forumla Close Date - TODAY(). Based on what has been mentioned above wouldnt this example also yeild a negative result?
Charlene