The following are configuration formats for output of numeric data via EL syntax. They are available for updating data of Numeric-type Data Item in Update Data or setting values for each Task. In addition to fixed values and referencing Numeric data, you can also reference the summary row values of Numeric columns in Table-type Data Items for data updating settings. Values from individual rows other than the summary row cannot be referenced.
BPMN Icon: ［Update Data]
Fixed Value
| Format | Assignment Value |
|---|---|
| 123.45 | 123.45 |
Numeric-type Data Item
| Format | Assignment Value |
|---|---|
| #q_numeric | 12345.67 |
| #q_numeric2 | 1.1 |
| #q_numeric + #q_numeric2 | 12346.77 |
| (#q_numeric + #q_numeric2) * 1.05 / 12 | 1080.34 |
Numeric column summary row in Table-type Data Item
| Format | Assignment Value |
|---|---|
| #q_table.summary['field_name'] | 567.89 |
| #q_table.summary['field_name'] * 0.05 + 0.005 | 28.39 |
Notes
- The operation result is truncated to fit the significant digits of the assignment's Numeric-type Data Item
- E.g. If you want integer rounding, add a “0.5″ in the expression
- In addition, If you enter thousand-separators other than specified in the number format in the Data Item or non-numeric characters, it will result in an error
- No configuration formats in "Update Data" clears data