# CalculatedColumn Process

Set calculated column together with its meta

namehour_rateworking_hours
John \$20/hrs 123 hrs
Marry \$30/hrs 112 hrs
Peter \$25/hrs 132 hrs
Donald \$40/hrs 89 hrs
``````
->pipe(new CalculatedColumn(array(
"total_meta"=>array(
"exp"=>"{hour_rate}*{working_hours}",
"type"=>"number",
"decimals" => 4,
"prefix"=>'\$'
)
)))
``````
namehour_rateworking_hourstotal_meta
John \$20/hrs 123 hrs \$2,460.0000
Marry \$30/hrs 112 hrs \$3,360.0000
Peter \$25/hrs 132 hrs \$3,300.0000
Donald \$40/hrs 89 hrs \$3,560.0000

The example demonstrates usage of `CalculatedColumn` process. The CalculatedColumn process creates new column and use formula to create value. As you may see there are two ways to enter formula. You can define formula in string and wrapped field name in bracket `"{hour_rate}*{working_hours}"`. Second option, you can define your own custom function to calculate value as you see the `"total_by_func"` in above example.

``````<?php
require_once "MyReport.php";

\$report = new MyReport;
\$report->run()->render();
``````
``````<?php

use \koolreport\processes\ColumnMeta;
use \koolreport\processes\CalculatedColumn;

//Step 2: Creating Report class
class MyReport extends \koolreport\KoolReport
{
protected function settings()
{
return array(
"dataSources"=>array(
"data"=>array(
"class"=>'\koolreport\datasources\ArrayDataSource',
"dataFormat"=>"table",
"data"=>array(
array("name","hour_rate","working_hours"),
array("John",20,123),
array("Marry",30,112),
array("Peter",25,132),
array("Donald",40,89),
)
)
)
);
}
protected function setup()
{
//Prepare data
\$this->src("data")
->pipe(new ColumnMeta(array(
"hour_rate"=>array(
"type"=>"number",
"prefix"=>'\$',
"suffix"=>'/hrs',
),
"working_hours"=>array(
"type"=>"number",
"suffix"=>' hrs',
),
)))
->saveTo(\$source);

//Save orginal data
\$source->pipe(\$this->dataStore("origin"));

//Pipe through process to get result
\$source->pipe(new CalculatedColumn(array(
"total_meta"=>array(
"exp"=>"{hour_rate}*{working_hours}",
"type"=>"number",
"decimals" => 4,
"prefix"=>'\$'
)
)))
->pipe(\$this->dataStore("result"));
}
}``````
``````<?php
use \koolreport\widgets\koolphp\Table;
?>
<div class="report-content">
<div class="text-center">
<h1>CalculatedColumn Process</h1>
<p class="lead">Set calculated column together with its meta</p>
</div>

<?php
Table::create(array(
"dataSource"=>\$this->dataStore("origin"),
"cssClass"=>array(
"table"=>"table-bordered table-striped table-hover"
)
));
?>

<i class="fa fa-arrow-down" style="font-size:24px;"></i>
<pre style="font-weight:bold"><code>
->pipe(new CalculatedColumn(array(
"total_meta"=>array(
"exp"=>"{hour_rate}*{working_hours}",
"type"=>"number",
"decimals" => 4,
"prefix"=>'\$'
)
)))
</code></pre>
<i class="fa fa-arrow-down" style="font-size:24px;"></i>

<div style="margin-top:20px;">
<?php
Table::create(array(
"dataSource"=>\$this->dataStore("result"),
"cssClass"=>array(
"table"=>"table-bordered table-striped table-hover"
)
));
?>
</div>

</div>``````

### What People Are Saying

"KoolReport helps me very much in creating data report for my corporate! Keep up your good work!"
-- Alain Melsens

"The first use of your product. I was impressed by its easiness and powerfulness. This product is a great and amazing."
-- Dr. Lew Choy Onn

"Fantastic framework for reporting!"
-- Greg Schneider