To Setup 'Automatic calculation'

There are some cases that automatic calculation on the entered number is needed in Workflows with number entering such as the total value of items in advance money application flow or as consumption tax on goods purchasing flow. Here is the explanation how to calculate numeric data together and how to use the total value of the number entered in the table.

To Define Arithmetic Expression in Numeric Type Data

expression-en.png

Click [Edit] button in detail setting screen of Numeric type data item. Enter arithmetic expression in the [Expression] field. The available elements are as follows:

  • Reference values of other numeric data item : data['data definition number']
  • Reference aggregation values from other tables type data : data['data definition number'].summary['column number']
  • Number
  • Four arithmetic (+, -, *, /)
  • Brackets

Sample ： Expression entry

  • ((data['1'] - data['2']) * 5 + 12.345) * data['3'].summary['2'] / data['4']
  • (data['0']*data['1'])*(1-data['3']/100)+data['5'].summary['3']

To use aggregate values of the Table type data

option-en.png

In advance of using aggregate values of the Table type data, select [Numeric] in the Table type data detail setting, and check on [Show total value at the bottom of list.]

 

To Setup Permission for Automatic Calculation

For performing automatic calculation on Numeric type data with expression, [Permission] must have been set as follows.

  • Numeric type data which expression have set : [Read Write]
  • Data items that are used in expression : [Read Write] or [Read Only]
 

To Confirm Calculation Results

Form-en.png

The calculation results can be checked in the Preview screen. Select property of the Task in Process Diagram screen, and click [Operating Task Screen Preview] . Enter numeric data and check the result if it is correct.

It cannot be confirmed in Preview screen such as when you need to enter more than one task.

 

Notes

  • Numeric data item which is set expression can not be used in the expression of another numeric data item.
  • Also available to Message Start Event and Message Throwing Intermediate Event.
  • The calculation will not be performed correctly if the data item that are used in expression was not entered (empty).