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: