Eval Data

Description

Allows for the evaluation of mathematical expressions using Scaffolding data sets.


Parameters

NameRequiredAvailable InDefault ValueDescription

[default] / name (Field Name)

 (tick)

 

The name of the field the evaluated result will be stored in. Must be unique.

format (Display Format)

 (error)

 

The format the resulting number should be converted to. Follows the standard java.text.DecimalFormat rules.


Editor View


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