I have a field which is stored in the database (SQL Server) as a float. In the universe it is a dimension with data type number. In my report it defaults to 2 decimal places (1.23) I can use a custom format to change the number of decimal places but the records in the database have a variable number of decimal places, it could be 1.23 or 1.234 I want to display the data exactly as it appears in the database without adding to removing any decimals. For example changing 1.23 to 1.230 is not correct. Any ideas on this? Perhaps I can convert the float into a string?
Have you tried setting the number format to #.#