Calculate two number fields using token calculator in workflow.

asked on January 26, 2017 • Show version history

I am having difficulty counting two fields together in workflow using the token calculator.

I have a form where a user enters a value called Invoice_Value (Currency Value). In my form process modulator I start a workflow. The workflow needs to take that Invoice_Value and add it to a value field I retrieve from SQL via a query lookup in workflow.

When I test the token calculator using numbers without a decimal point ex (200 +200) I get a successfull result of (400).

When I test with a decimal point ex(200.10 + 200.10) the test fails with an error ( Expression: 200.10 + 200.10 Message: Parser matched an invalid token as a number., )

I have edited the values I receive to always have 2 decimals after the decimal piont using the token editor. I have also clasified the tokens as "numbers" & "String" values.

Has anybody else had this issue? If possible could someone assist me is resolving this.

Token Calculator.jpg (48.12 KB)

| Download

0 0

replied on January 26, 2017

What version of Workflow are you using?

0 0

View 1 previous reply

replied on February 1, 2017

Hi Miruna

Any update for me on this?

0 0

replied on February 1, 2017

I can't reproduce the behavior. Have you tried tracking your token values? Depending on the data type of the columns in question, sometimes the values can be padded with spaces, which could make Workflow treat them as text.

It's probably best you open a case with Tech Support so they can take a closer look.

0 0

replied on February 3, 2017

The issue was caused by Windows regional settings using a comma instead of a period as the decimal point. Once that was addressed, Workflow ran fine.

0 0

Question

Question

Calculate two number fields using token calculator in workflow.

Replies

Sign in to reply to this post.