[SOLVED] Format Query Field result

I have a Query field correctly pulling data from 2 databases and displaying the results in a multi-column field in a user profile tab.

Part of the query is SELECT ... (b.points-a.spoints)/10 AS people ... which correctly calculates the column value.

When the [column_people] is displayed in the field it is displayed as 27.0000 and what I am wondering is there some way to format the number display without the decimal and zeros?

Thanks

BTW
Joomla 3.4.1
CB 2.0.9
PHP 5.5.14
5.5.43-37.2 - Percona Server

CB Query Field applies no formatting to it. The formatting is either in the database query results already or SQL is doing it. See the below documentation for numbers if you need to reformat it in your query.

dev.mysql.com/doc/refman/5.6/en/numeric-functions.html

More specifically you need to use the following to remove any decimal places.


You may want to round it though if you expect to have decimal values.

Kyle:

Thank you for the assistance once again. Based on your example, I realized I had failed to place a set of brackets around the total calculation, resulting in an error.