function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sean M. O'MeallySean M. O'Meally 

Using Numbers, Currency, and Percentages in Formulas subtopic

Under the "Calculate Accumulated Interest on an Account" section, I'm having trouble figuring out where exactly to insert the following function in the Interest Rate field:
Principal__c * EXP(Interest_Rate__c * (YEAR(TODAY()) - VALUE(YearStarted)))
DeepthiDeepthi (Salesforce Developers) 
Hello Sean,

The section in this module is looking for calculating the Accumated Interest. So create a formula field for accumated interest and execute the above formula in it. It will work.

Please let me know if you need any help!
Regards,
Deepthi
Anne-Marie Costantino 5Anne-Marie Costantino 5
Hi Deepthi, I am having the same issue with this trailhead exercise.  I have created a new custom field call Accumulated Interest, now when I enter the above formula, I get an error message that YearStarted field does not exist. Any suggestions :)