formatting numbers in sap business one query manager

Ammammata <[email protected]> Mon, 17 Aug 2020 09:33:02 -0000 (UTC)
Newsgroups comp.databases.mysql
Organization solani.org
Message-ID <[email protected]>
rif. https://i.imgur.com/Mvp40nW.png

(ref. 4, Apr and following)
the standard output is good, but it displays two un-needed decimals (it's a 
quantity)

(ref. 1, Prev & Jan)
I tried convert(int, x): decimals disappear, zeroes disappear, but the 
number is left aligned

(ref. 2, Feb)
I tried format(x, '0'): decimals disappear, zeroes are visible, but - as 
above - the number is left aligned

(ref. 3, Mar)
I tried format(x, 'n'): decimals are back, zeroes are visible, but - again 
- the number is left aligned

how can I set the standard output to no-decimals for this query only?

TIA

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........