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 #.#
1 Like
I was able to figure this out, just had to use the Format Number function and add some extra hash marks. I think this will break if there are more than 10 decimals but that none of the values in the database are that precise.
=FormatNumber([Required Qty];"###0.##########")