Product:TIBCO Cloud Spotfire
Versions:All
Summary:
When converting a Real column to String not all decimals are included
Details:
When using the String() function to cast a Real column to a String column, only two decimals are included regardless of how many decimals are displayed under Column Properties/Formatting.
For example, if a Real column called [Values] included a value for Pi of 3.14159265, using String([Values]) would output 3.14.
Resolution:
To avoid the undesired rounding, use the Concatenate() function to convert the entire Real number to a String column when a space is added before the column. For example:
Versions:All
Summary:
When converting a Real column to String not all decimals are included
Details:
When using the String() function to cast a Real column to a String column, only two decimals are included regardless of how many decimals are displayed under Column Properties/Formatting.
For example, if a Real column called [Values] included a value for Pi of 3.14159265, using String([Values]) would output 3.14.
Resolution:
To avoid the undesired rounding, use the Concatenate() function to convert the entire Real number to a String column when a space is added before the column. For example:
Concatenate(" ", [Values])
In the above example, Concatenate(" ", [Values]) will produce 3.14159265