Forms Incorrectly Evaluating Values?

asked on July 5, 2016

We have a form that has 2 number fields. Both are setup to use 2 decimals and the comma separator. After the form is submitted it goes to an exclusive gateway that has 2 conditions. The first one is /dataset/Approval/MT_1_3>/dataset/Order_Total and the second one is /dataset/Approval/MT_1_3</dataset/Order_Total. So it is basically comparing values from 2 different fields. Depending on if MT_1_3 is greater or less than Order_Total it goes a different route.

We have run several tests with the following values for the 2 fields mentioned above:

MT_1_3 Order_Total Outcome
$500.00 $700.00 Correct
$500.00 $40.00 Correct
$500.00 $90.00 Incorrect
$500.00 $70.00 Incorrect

So with the above outcomes, it seems as though the entire number is not being evaluated, but just the first digit. Has anyone else had this issue?

Using Forms 10.1.0.579

1 0

SELECTED ANSWER

replied on July 5, 2016 • Show version history

It is because the values of the number variables are evaluated as string not number when the condition contains two variables. The workaround for this is to force converting string to number in the condition, please use "/dataset/Approval/number(MT_1_3)>/dataset/number(Order_Total)" and "/dataset/Approval/number(MT_1_3)</dataset/number(Order_Total)" instead

2 0

replied on July 6, 2016

Can the Forms Administration Guide be updated to include this information?

2 0

replied on July 6, 2016

We will update the documentation here https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/Forms/Content/Processes/Process-Modeler/Using-Conditional-Expressions.htm

0 0

Question

Question

Forms Incorrectly Evaluating Values?

Answer

Replies

Sign in to reply to this post.