Mathematical functions: Sum and average

We now want to define sums and averages for the value columns. In order to do that, we have to know, how many lines we have to leave blank for the archive entries. This is however not defined in the report but in the Report Generator. The number of entries in the list depends on the filter settings, with which we lateron will call the functions ("Print report", "Export report" or "Picture switch - REPORT").

In our example we will select a time filter of two minutes. As our archive records values every five seconds, this will make 24 entries for our report.

Enter the text "Sum" into cell A29. on.
Enter the text "Average" into cell A30.
Enter the function "=sum(B5:B25)" into cell B29.

Info

You either can type in the function, as described above. Or - instead of typing in "B5" and "B25" - you can select the cells with the mouse.

Enter the function "=avg(B5:B25)" into cell B30.
In order the get the sums and averages in the columns C, D and E too, there is no need to type in the functions again. It is easier to copy the cells B29 and B30 and paste them into the other columns.

Info

If you copy functions with cell addresses in the Report Generator, the cell addresses are automatically adapted.

Save the report under the name "Archive".

The reports are saved in the directory Reports as defined in the project configuration and get the name extension *.xrs.