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 | Migratable to Cloud? | Default Value | Description |
|---|---|---|---|---|
[default] / name (Field Name) |
|
|
| The name of the field the evaluated result will be stored in. Must be unique. |
format (Display Format) |
|
|
| The format the resulting number should be converted to. Follows the standard java.text.DecimalFormat rules. |
Editor View
Not applicable.
Macro Edit View
Not applicable.
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 |
|---|---|
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.