Smarty Calculation with Database Value

Question

I am trying to make a calculation based on the database value.Basically I am displaying some data by following code in my tpl file

<table cellpadding="2" cellspacing="0"> 

{foreach from=$data item=item key=key} 

  <tr> 
      <td>{$item.Country}</td> <td>{$item.count}</td> <td>{$item.sum}</td> 
  <tr> 

 {/foreach} 

</table> 

Now I need to make a calculation based on {$item.count} and {$item.sum} By searching I am finding below smarty math calculation formula

{* $height=4, $width=5 *}
{math equation="x + y" x=$height y=$width}

But can not assign my database variable.How can I do this

Answer 1

You can do basic math without the math function.

{assign var=x value=12}
{assign var=y value=4}
{assign var=sum value=$x+$y}
{assign var=difference value=$x-$y}
{assign var=product value=$x*$y}
{assign var=quotient value=$x/$y}
{assign var=modulo value=$x/$y}
{assign var=operations value=(($x/$y)*($x-$y)*9)-1}
<p>{$x} + {$y} = {$sum}</p>
<p>{$x} - {$y} = {$difference}</p>
<p>{$x} * {$y} = {$product}</p>
<p>{$x} / {$y} = {$quotient}</p>
<p>{$x} % {$y} = {$modulo}</p>
<p>(({$x}/{$y})*({$x}-{$y})*9)-1 = {$operations}</p>