How to disable decimal values in confluence and display the total?

[SKR]

Hi,

Can anyone guide me to change displaying of decimal values setting?

I will be displaying results from SQL and would like to convert decimal values into Integer in confluence, but I do not want convert this using SQL.

I also would like to display total at the end of each column without using sql.

I have tried by changing in general configuration under confluence admin but it doesn't make any difference so please let me know how to achive this?

Thanks

[Bob Swift · Accepted solution]

You need to do that with SQL using the round function (for postgres) or equivalent for your database. Select the Auto total row (autoTotal) parameter to get a total row.

[Matthew J. Horn]

Yes, do it in your SQL statement. All major SQL databases have rounding functions.