Report functions

Previous chapterNext chapter Show allShow all    Hide allHide all

For the formation of the report, different functions are available. The input of the functions is done in the input row of the report.

Processing functions

Defined access to selected zenon data
(online and archive values, user, computer names etc.)

Report functions

- formatting functions

- calculating functions

=archive(1,"value","bottom")

All values of the archive variable 1 are displayed downwards from the cell

=sum(a4:d4)

The contents of the cells "a4" to "d4" are totalled. (Cell must have a value format)

=now()

Output of date/time

If several cells should be filled with the same function, the source cell and the target cells are to be marked and the infill functions started in the Edit/Infill/Right, Edit/Infill/Down menus. References to cell co-ordinates in the function are automatically adjusted.