This documentation is for the Server version. If you're looking for the Cloud app documentation, visit Evaluate Data
Description
Allows for the evaluation of mathematical expressions using Scaffolding data sets.
See the Storing Data and Using that Data for Calculations guide as an example on how to use this macro. You may also try it out for yourself on our demo site.
Parameters
| Name | Required | Available In | Migratable to Cloud? | Default Value | Description |
|---|---|---|---|---|---|
[default] / name (Field Name) | Yes | Server, Data Center | No | The name of the field the evaluated result will be stored in. Must be unique. | |
format (Display Format) | Optional | Server, Data Center | No | The format the resulting number should be converted to. Follows the standard java.text.DecimalFormat rules. |
Notes
- The actual expression being evaluated goes inside the macro content. Other fields in the same context can be referenced in the calculation. See the example scaffold above for more details.
- The following functions can be used to perform evaluation:
Function
Syntax
Average
avgtable("TableName", "ColumnName")
Sum
sumtable("TableName", "ColumnName")
Rounding
round(value, number of decimal places)
- Despite the name, the Average and Sum functions also work with the repeating-data macro as well.
Tutorial Examples