Eval 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

NameRequiredAvailable InMigratable to Cloud?Default ValueDescription
[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