Here's the situation....
I have two fields
{!Installment__c.Principal_Due__c}
and
{!Installment__c.Interest_Fee_Due__c}
All I need to do is add the two values together for a combined figure.
But, the fields starts with "AUD " for example AUD 500.00
So I need to trim the first four characters of the two fields and then add them together.
This is the first time I have tried to embed a formula into an email template, I have tried using the TRIM function and surrounding the formula with {! and } but I can't even get this work.
Any help would be awesome, thanks!
2 个回答
As opposed to trying to have the formula within the email template, you can just add a formula field to the installment object that adds these two fields together and then just include that formula field in your template.
