value in Query align by left

[Former Member]

Hi Experts,

I have a problem in B1 query.

For example my query is as follow

-

---

Select 1.001

-

---

B1 query will show

1 : align by right

The problem is that the value is not 1.001

If I change the query

-

---

Select '1.001'

-

---

B1 query will show

1.001 : align by left

The value is ok, but the alignment is left. How to let the value align by right?

Glen

[Former Member · Accepted solution]

If you use select 1.001, the result is controlled by decimal setting-> amount, when you set it 4, it will display 1.001 in sap.

[Former Member]

That is normal behavior of query result. The first one is number so that will be aligned right. The second one is text so that will be left. Everything within ' ' would be a text no matter it is letter or number.

Thanks,

Gordon