Question

Evaluating Number and Currency Not Working

Workflow Version 12 Self-Hosted

Updated December 12

asked on December 12

I have a workflow that does not seem to be evaluating number and currency values correctly.

I created a token using the "Assign Token Value" activity named "POLinesTotal" and set it to a Currency tag.
I created another token using the "Token Calculator" activity named "POTotalDistributionAvailablePlus10PercentMulti" and set it to a Number tag. It takes a value from a database lookup and *1.10.
I then have a "Conditional Sequence" activity that is set to "If all these conditions are true... POLinesTotal is greater than POTotalDistributionAvailablePlus10PercentMulti.

I have an instance where this doesn't seem to be evaluating correctly and I'm trying to figure out why. The values being user are:

POLinesTotal: 9793.00
POTotalDistributionAvailablePlus10PercentMulti: 10772.3000

It says that POLinesTotal is greater than POTotalDistributionAvailablePlus10PercentMulti, which is not the case. Is this a bug in Workflow? I am using Workflow 12.0.2510.3321.

0 0

Replies

replied on December 12

It's a bug with currency tags. They evaluate as strings conditions. Use Number instead for any cases where you are comparing numbers. (And keep in mind that the type of the token on the left hand side of the condition determines the data type for the evaluation.)

1 0

replied on December 12

Thank you for the confirmation, Miruna and the snippet about what determines the data type for evaluation.

0 0

replied on December 12

If I change the POLinesTotal token to a Number tag instead of a Currency tag it evaluates correctly. I would have expected Number or Currency to evaluate the same.

0 0

You are not allowed to follow up in this post.

Question

Question

Evaluating Number and Currency Not Working

Replies

Sign in to reply to this post.