silreporting_sumTable

Syntax

silreporting_sumTable(silTable)

Description

Calculates the sum per columns for a provided table.

Parameters

Parameter name	Type	Required	Description
silTabel	SILReportingTable	Yes	The table to be transposed.

Return type

SILReportingTable

The table with the sum calculated in the footer.

Example

In the fallowing example you can see the sum per columns for a table which contains the number of opened and resolved issues for a list of projects.

string [] projects = "TEST|FIBR|STEI|GRBI|HGES|RGIS";
string [] resolvedIssues;
string [] openedIssues;
for(string p in projects) {
    resolvedIssues[p] += countIssues("project = " + p  + " AND status in (Done, Closed, Resolved)");
    openedIssues[p] += countIssues("project = " + p  + " AND status not in (Done, Closed, Resolved)");
}
    
SILReportingHeader [] headers;

SILReportingHeader h1;
h1.name = "Opened Issues";
h1.sortable = "sortable";
headers += h1;
    
SILReportingHeader h2;
h2.name = "Resolved Issues";
h2.sortable = "sortable";
headers += h2;

string [][] rows;
for(string p in projects){
    rows += {openedIssues[p], resolvedIssues[p]};
}

SILReportingTable table;
table.headers = headers;
table.rows = rows;

return silreporting_sumTable(table);