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 ] ...........