top of page

Calculation Element

On the left are the types of calculation you can select, and on the right is a list of all the numeric fields in the table.

  • Sum: Total up the values for the selected field in the selection of records you're publishing: select the field you want to total up from the list of numeric fields.

  • Count Records: Output a count of the number of records being published (no need to select a field)

  • Average: Output the average value for the selected field in the selection of records you are publishing

  • Maximum: Output the maximum value in the selected field for the selection of records you are publishing.

  • Minimum: Output the minimum value for the selected field in the selection of records you are publishing.

  • Median: Output the median value for the selected field in the selection of records you are publishing.

  • Discount: Discount the value in the selected field by the specified percentage.

  • Markup: Mark up the value in the selected field by the specified percentage.

  • Record Number: Output a sequential number as each record is published. The default starting number is 1, but you can specify a different starting number.

  • Add value: Add the specified value to the value in the selected field as each record is published.

  • Subtract value: subtract the specified value from the selected field as each record is published.


Note: the calculations are dynamic and they are not saved in the database - your data will not be changed!

For example, suppose we want to publish a special offer catalogue with all prices discounted by 20%. We would set up a Calculation Element like this:

bottom of page