KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to build calculation on footer of table? #54

Open tee opened this topic on on Aug 3, 2017 - 2 comments

tee commented on Aug 3, 2017

Hi KoolReport,

I can get the summation values for Apples, Oranges and % of oranges by using

Table::create(array(
        "dataStore"=>$this->dataStore('report1a'),
        "showFooter"=>true,
        "columns"=>array(
            "Apples"=>array(
                "footer"=>"sum",
            ),
            "Oranges"=>array(
                "footer"=>"sum",
            ),
            "%oranges"=>array(
                "footer"=>"sum",
            )
    ...

, but on the footer of Accumulated's column i want to have the value of Oranges/Apples instead of total up of Accumulated values. How to do it? Thanks a lots.

tee commented on Aug 3, 2017

Add on: Let's say i want to add one more column named Avg to calculate number of Oranges based on record (Ex: F3=C3/2, F4=C4/3, ..., F=C7/6)? How can i do it?

KoolReport commented on Aug 3, 2017

Your data tables need alot of customization, I suggest that you should use raw data and build your own table.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None