Mathematical operations in templates

[gene]

I wanted to add mathematical formulas in templates. For example in the product template, I wanted to show customers the % discount of an item. How do the template do this? I tested the product template and write, say, (1 - Sale Price/Retail Price)*100 where Sale Price and Retail Price are pulled out from database. However, when published, it just show what I write.

[Jim]

There are no math functions in the template code. You would have to use the CALL tag and send the parameters to a script that you write and have it return the answer.