Space-Time Cube: Number Format/ Rounding

[S9820]

Hi all,

I'm trying to create a space-time cube with the aggregation shape type set to "defined location" (census tract boundaries). To do this, a unique Location ID is required which I have, but not in the correct format (required format: String, Numeric). I've tried creating a new field and changing the setting to the proper numeric format but I'm still unable to preserve the location ID values and preventing rounding.

Ex. location ID such as '5350007.01' either rounds to 5350007.00 or 5350007

How can I preserve the original formatting?

[DanPatterson]

if required format is String or Numeric, what is wrong with your string value that you have shown?

[S9820]

the space-time cube only recognizes string values for the 'Location ID'. the decimals get lost when stored in a long/short format and therefore lose their uniqueness. However, when I store the data as a double (numeric) the tool doesn't recognize the field. 

[DanPatterson]

hence use string format since text or integer is supported and a string representation of a decimal value will be unique