Welcome to the Veson Nautical Knowledge Base. In the Help Center, you can view the same articles and contact support as needed.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

Error rendering macro 'excerpt-include' : No link could be created for 'Veson IMOS Platform Documentation'.

You can use an aggregate function in the Report Designer to average, count, sum, or perform another function on column data. You can do very powerful comparisons and find out true performance values. For example, you might want to find the average return for the whole fleet, the count of all voyages, or the sum of the money you are making per voyage.

  1. To use a field or column in a function, on a joined table in the Report Designer panel, click  and then click Aggregate.
  2. The type of aggregation possible depends on the data type of the field. In the Report Designer panel, click  to the right of the field name and select one of the following:
    • Avg: The average of all non-null values in the column
    • Count: The count of all non-null values in the column
    • Max: The maximum of all non-null values in the column
    • Min: The minimum of all non-null values in the column
    • Sum: The sum of all values in the column
  • No labels