Analysis of your ecommerce data often requires calculations. Apsona offers calculated fields in its ecommerce reporting module presently for Zen Cart and osCommerce. Since the calculated fields are javascript based, users can now run complex reports with ease whether its is their Zen Cart products and their osCommerce products. Dependence on IT teams is a thing of the past, and quick, fancy reports can be run in minutes.
An example below shows how simple it is to use and apply calculations in reports.
Example:
$r['Final Selling Price']+$r['Shipping Price']-$r['Landed Cost Price']-$r['Shipping Cost']
To use the feature:
* Click the add column drop down in the report wizard and choose the field calculated value.
* Change the column name for the field to match the calculation. Example: Profit or totals and so on.
* In the calculation box enter the calculation. Syntax for the fields are : $r['fieldname']. The field name should be the exactly the same as chosen for the report.
* Choose the result type of the calculated field from the drop down, depending on the data type you want the calculated field to render.
* Click OK. Save and run the report and the report will have the calculated value.
Try Apsona reporting and experience its power. Feedback will be welcomed.