Support Article
Decision table column values are converted to single digit value
SA-39857
Summary
In a Decision table, the user is given a column source as Parameter type Text and the column values are converted to single digit value or exponential value and is causing their validation to fail and system is giving wrong output.


Error Messages
Not applicable
Steps to Reproduce
1) Create a Decision table
2) Give the column source as Parameter type Text
3) Populate large integer values into it.
Root Cause
This is expected behaviour. The current logic will check if the value is of type numeric, if yes the value is converted to numeric using the below code
cell.setValue(Double.parseDouble(cellValue));
It will convert 001 to 1 and large integer to exponential format.
Resolution
Put the values in quotes to pass it as a string. This will not perform any conversion to exponential format.
Published August 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.