Select the Simple Formula tab and insert the - Subtract operator after the second close parenthesis at the end of the formula (the close parenthesis for the YEAR function).In place of date in the YEAR function, insert the TODAY function.Select the Advanced Formula tab and insert the YEAR function after the * Multiply operator.Select the Simple Formula tab and insert the * Multiply operator after the Interest_Rate_c field.In place of number, build the formula for interest rate: first, insert the field we made earlier, Interest_Rate_c, between the parentheses.EXP(number) returns e raised to the power of number. Select the Advanced Formula tab and insert the EXP function. We want to multiply Principal by e raised to the power of the interest rate, multiplied by the number of years that the account has been open. Insert the field Principal in the formula editor.In Formula Return Type, select Currency and click Next.In Field Label, enter Accumulated Interest.In the Object Manager, click Account | Fields & Relationships and click New.Now we can adapt the formula to fit our fields. The number of years the account’s been open The principal amount of money in the account
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |