Spotfire issue converting Real to string , loss of precision

[abhinay .]

while i change the data type of a Real column to String,converted value just show up two decimal place.

Eg:

0.0004678 -> 0.00

0.02876 -> 0.03

Please let me know if some one have faced the same or have a solution/work around.

[Fredrik Rosell]

Hello,

 

If you are e.g. adding a calculated column, and converting your real column to a string there, using String([yourcolumn]), it will indeed round it to 2 decimals. There is currently no way to change that. You may want to vote for the idea "Additional string function where you are able to change the rounding settings" in the TIBCO Ideas Portal: https://ideas.tibco.com/ideas/TS-I-6205.

If your use case allows it, consider changing the data type from the Data panel instead:

1. Open the Data Panel

2. Select your column

3. Select show details

4. Change the data type to String.

 

 

Best Regards

Fredrik