+1I need to consistently show 2 decimals, including when the number is a full integer, or only has 1 decimal. Searching the forum I found references to custom_display_format, but I have no idea how/where to implement it.
For example, here it should be 2.25, 1.00, 2.00 and 1.50:
Alternatively I could use a calculated field, but converting numbers to strings in sql for this purpose would be inefficient (and a lot of extra work and complexity), so I'd like to avoid it.
Best answer by Nathan
Hi
and when I enter 1.00 as a value then it sill displays the 2 decimal points as part of the output value. Please clarify which data type you are using in your example.
Hi
and when I enter 1.00 as a value then it sill displays the 2 decimal points as part of the output value. Please clarify which data type you are using in your example.
+1Hi
I was using a decimal:
As far as I can see there is no functional difference, other than that decimals might allow number bigger than 6 characters, somehow.
I changed it to NUMERIC, and it works just like you said, thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
