To prevent spam users, you can only post on this forum after registration, which is by invitation. If you want to post on the forum, please send me a mail (h DOT m DOT w DOT verbeek AT tue DOT nl) and I'll send you an invitation in return for an account.

Calculate values within process

Let's say i have a small process (purchase order e.g.) that has some monetary values (€). 
Is it possible within ProM to calculate with such values? 
For example i want to sum these values (see column 'money' below).

case activity timestamp money
payment1 order 01012019 010101
payment1 voucher 01012019 010102 100
payment1 received 01012019 010103
payment1 three-way-match 01012019 010104
payment2 order 01012019 010105
payment2 voucher 01012019 010106 600
payment3 voucher 01012019 010107 300
payment3 received 01012019 010108

In ProM i want to filter only cases with the step 'order' and then calculate the total value of column money (in this simple example 700€).

Comments

  • hverbeekhverbeek Posts: 383
    Hi,

    ProM allows you to filter in all cases that have the step 'order', but there is no functionality (yet) to perform calculations like you describe.

    A possible workaround could be to filter the cases using ProM, to export the resulting log to a CSV file, and then to use Excel or something like that to do the computations.

    The alternative would be to develop a dedicated ProM plug-in to do the computations.

    Kind regards,

    Eric.
Sign In or Register to comment.