Open topic with navigation

> Making reports look good / Properties / Function properties

Function properties

Find these properties

Select the information on your report you want to work with; from the Properties pane, select Function from the Appearance area and then click the finder button . If you can't see the Appearance area, click the Categorized button at the top of the pane.

Function options

Function

Description

None

This is the option applied to a variable or expression when added to a report. The report displays the value for that variable or expression.

Sum

Displays the total value of variables or expression in a report.

Use Sum in a:

  • Footer section to total all values in the section above. This is the most common use for sum.
  • Details section to give a running total of the values on the report.
  • Group section to give a running total for each group.

Avg (average)

Displays the average value of the information returned through the variables or expressions.

Use Avg in a:

  • Footer section to show the average of all the values in the section above.
  • Details section to show the average at each point in the list of values.

Min

Displays the minimum value of the information returned through the variables or expressions.

Use Min in a:

  • Footer section to show the minimum of all the values in the section above.
  • Details section to show the minimum value at each point in the list of values.

Max

Displays the maximum value of the information returned through the variables or expressions.

Use Max in a:

  • Footer section to show the maximum of all the values in the section above.
  • Details section to show the maximum value at each point in the list of values.

Count

This option replaces the values returned by variables or expressions with a numbered list. For example, in Preview mode, your report shows the following values: 32.1, 58.3 and 49.0. If you apply Count to the information, your report will replace those values with: 1, 2, and 3.

Count ignores any nil values. If you want your report to list records with a contact address any record which does not include an address is missed from the report.

Use Count in a:

  • Group section to show the total number of records within a group.

    Tip: To reset the numbering in each group use Reset Section in the Behaviour area of the Properties pane.

  • Footer section to show the total number of records within the details section.

CountAll

CountAll works in a similar way to Count as explained above, but it will increment the count for nil values.
CountUnique CountUnique works in a similar way to Count as explained above, but it will only increment the count if a value is unique; i.e. it is different to all previous values.

Go to top