print reportDataAverage

Calculates the average value of a row or column of data. Note that in an ideal world the column / row will only contain numerical data. Either way, Excel will allow strings - they should (in theory) be ignored. Either that or they get counted as 1 (integer one).

Example usage:

// This examples adds an average as the last row of reportData
// simple test class with other methods ignored
class testReport extends reportBase {

		function _run() {
			// insert other rows above, now add some sums to the columns
		// our reportData contains, col1,2...4 and a total
			$this->getReportData()->addRow(
				array(
					'col3' => new reportDataAverage(0, 3, $this->getReportData()->sumColumn('col3')/$this->getReportData()->getCount()), // avg only col3
				)
			);
		}
	}

Methods

public __construct([$inRow = null], [$inColumn = null], [$inStringValue = 0], [$inStringFormat = null], [$inOptions = array()])

Creates a new instance

public reset()

Resets the object to defaults

public render($startRow, $startCol, $endRow, $endCol, [$sheetRowStart = 5])

Returns the sum formula in Excel format

Inherited Methods

<  1  >

Posted by: Scorpio Documentor (Writer), in Report on 08 May 2010 @ 16:46

Tags: countable, iteratoraggregate, report, reportdataabstract, reportdataaverage, traversable,

Creative Commons License
This work is licenced under a Creative Commons Licence.

Prev Next
May 2010
Su Mo Tu We Th Fr Sa
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31