Email Template Help

[Nishan Perera]

Hi,

Is there any possibility add calculation to email template.

for an example, I want to get the count of cases pending for more than 7 days in to the email body.

Dear User,

You have got "10" pending cases more than 7 days in your pipeline

Is the calculation or formula can be added to email body ?

[eymen-elkum]

Hi,

Yes, it is possible,

Just add custom fields to the target entity to hold the values, and write the formula to calculate them, and you will be able to use in the email.

I think this is the easiest & best way.

[espcrm]

Haven't done email template calculation before, but I believe you would need to create an actual field first then insert that field (using Formula or something to calculate that first field).

You can't just use Email Template then straight forward and do something like: {cost}*{quantity}

You would need to have a new field first. For example {price}, then use Formula to calculate then in your email template you would do something like this.
Price: {cost} x {quantity} = {price}

[Nishan Perera]

Hi, Thanks for the replies. will try it out and let see the easiest way and the outcome.