Re: formatting numbers in sap business one query manager

On 8/17/2020 5:33 AM, Ammammata wrote:
> 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
> 

What about TRUNCATE(x, 0); ?

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
[email protected]
==================