Re: formatting numbers in sap business one query manager

On 17/08/2020 11.33, 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?

you could try FLOOR(x), this will still be a numeric value while 
FORMAT() returns a string, which makes your alignment to look wrong in 
the program you use to display the data in.

-- 

  //Aho