Calculations in templates?

[Systems Navigator]

General question,

Is it possible to make a calculation in an email template with two fields? For example the value of one field multiplied by the value of another?

Thanks


6.0 Pro is the version I use

[Systems Navigator]

Anybody know a trick to do this? Maybe in the HTML code of the template?

Help is really appreciated!

[andopes]

Let us know in details what you want to accomplish.

Regards

[Systems Navigator]

Hello André and other fellow users,

Actually what I want to do is the following:

I have made a custom module that is related to the product catalog. This module uses the list price of the product that I selected, but sometimes I would like to apply a discount on this price. This discount can vary, so I created a field in the custom module with the amount of discount. What I would like is that in the template that I want to be sent, the list price is multiplied by this discount.

For example: the list price is $300 and the discount is 40% (0.4) then I would like to calculate the discount by multiplying the {listprice} * {discount%} = $300 * 0.4= $120
Next I would like to calculate the discount price by subtracting the discount from the list price:
{listprice} - {discount} = $300-$120= $180.

Since I found out that the whole template is captured in a html code that you can edit, I thought this might maybe be possible. If this is possible, help is really welcome.

Thanks in advance!

OS: Windows 2003 Server R2
Sugar: Version 6.6.0 Pro
Webserver: apache 2.0.59
PHP: Version 5.2.5
Mysql: version 5.0.45

[Systems Navigator]

Anyone an idea?

thanks

[Systems Navigator]

bump.........

[Systems Navigator]

Anyone please?

[Systems Navigator]

Is there nobody who can tell if and how it is possible to make simple calculations in html code?

Please help.

[Systems Navigator]

bump......

[Systems Navigator]

bump.....................