In-Portal has powerful number formatting engine, that allows to format numbers, stored in database in the way you need using
sprintf function.
However I recently stumbled upon situation, where I need to remove trailing spaces from a formatted number, that was displayed, e.g. make "545.00" appear as "545", but keep "345.22" as is.
Patch attached gives ability to enable such behavior for any database field needed via adding "cut_zeros" option to field definition in unit config.
Ready for testing.
--
Best Regards,
http://www.in-portal.com
http://www.alex-time.com