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. This is not the same thing as the RecordNumber field in each record! This is a dynamic value that's created each time you publish the data.
  • 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:

Calculation element type

The Calculation Element enables you to tell CatBase to perform various calculations as your data is published. This affects only the published data; your actual data is not changed.

mark up markup price prices discount discounting

For more info about the different types of Element you can include in your Publishing Stylesheets, see the Elements tutorial.


To find out more about publishing data with CatBase, see the Publishing Projects Tutorial.

TOP DOG IN DATA PUBLISHING