How to remove decimal places on Grid Column.

[Former Member]

Hi experts,

I created a stored procedure with a quantity field. decimal(19,2) datatype.
When i populate it on  Grid using DI the value has decimal places and commas. so how do i remove the decimal places? the value must have comma's so i just want to remove decimal places only.

Thanks.

[edy_simon · Accepted solution]

Hi Weynard,

The only way you can do is to format your result as NVARCHAR.

Calculation decimal places is controlled by SBO and defined in

Administration-System Initialization-General Setting-Display Tab-Decimals in Query.

Regards

Edy

[Former Member · Accepted solution]

Hi Edy,

I tried using nvarchar datatype. but the problem is the Valu has no Comma's.

I'm using HANA DB.

Thanks

[edy_simon · Accepted solution]

Hi Weynard,

I am sorry, i have very minimum experience with HANA DB.

Maybe others can ?

Regards
Edy

[Former Member · Accepted solution]

Hi Edy,

Don't mind the HANA DB.. lets focus on Grid using DI..

I have a column Quantity. the values are,

500.00
1,200.00

10,300.00

173,500.00

What i want is to remove the decimal places using DI API. is there any way to format this values like this?the values should have comma's.

500.00

1,200

10,300

173,500

Thanks.

[edy_simon · Accepted solution]

Hi Weynard,

There is no way by using DI.

As I mentioned in my previous post, this is set in the general setting.

Regards

Edy

[Former Member · Accepted solution]

Hi Edy,

Thanks for responsing,