I am displaying price values from my database and using the following code to display them.
FORMAT(properties.price,0) as price
So a database value of 11000 shows as 11,000. The problem is that now hourly rates need to show so if the database for instance has a value of 5.8 it needs to display as that whereas currently is shows as 6.
Any ideas how I change the format to achieve this?