Support > Repository > Screen function > Summary of list display
ja | en

The maximum value, minimum value, average value, total value, number of each item can be displayed in the summary column of the list display screen.

The maximum value, minimum value, average value, total value, number of each item can be displayed in the summary column of the list display screen.

Fig. 1 Example of summary column display

The model definition of the sample application shown in Fig. 1 is shown.
Items to be outputted in the tabulation field are to be displayed in the list display.

Figure 2 Model definition for sample application

Setting summary column

Specify "Output control> list screen> summary column" of model item detailed definition.

You can specify "minimum value" "maximum value" "average value" "total value" "number". The contents that can be specified depend on the item type.(Described later)
Figure 3 is an example of a date type.

Figure 3 Specify "minimum value" and "maximum value" for the date type item

Figure 4 is an example of a numeric type.

Fig. 4 Specify "minimum value" "maximum value" "average value" "total value" "number" in the numerical type item

You can specify a numeric format for each section of the summary.For specifying the format, refer to "Numeric> Output formatPlease read.

Figure 5 Specifying numerical format

If the above format is unspecified (blank), the numerical format of the target item is reflected in the numerical value displayed in the summary column.

Figure 6 Numerical format of the item itself is used

Functions AGCOUNT, AGSUM, AGAVG, AGMAX, AGMINYou can get the value displayed on the screen by using.

Available types

Depending on the item type, the available operations are determined.

Item type minimum value Maximum value Average value Total value Number
String × ×
Integer/decimal
Date/Time × ×
Model reference × × × × ×
(Container of repetitive items) × × × × ×
(ID for repeated item container) × × × × ×

Unsupported item

This aggregation function does not correspond to the following items.(Definition will ignore it as well.)

  • Repeat item
  • Items in the repeating container
  • Items for which "○" is not set in "Store values ​​in database"

When the tally target is empty

When the value of the summarization target item is "empty" (no value), the minimum, maximum, average and total value are displayed as blanks.The number is displayed as "0".

Constraints on using built-in database

When using the built-in database (HSQLDB) bundled with Wagby, the average value is only an integer value.

Constraints on using cell join (row)

Cell join (row)There are restrictions on the layout when used together.For details, please read the link destination page.