topic Re: negative value fields in Application Development and Automation Discussions

negative value fields

Former Member — Mon, 30 Jul 2007 15:38:31 GMT

Hi friends,

I created a table but some fields are not accepting negavtive values I declared and Decimal.

Pls suggest datatype to accept negative values

thanks

karthik

Re: negative value fields

Former Member — Mon, 30 Jul 2007 15:44:02 GMT

You can use data element : WRBTR and domain WERT7

Thanks

Seshu

Re: negative value fields

Former Member — Tue, 31 Jul 2007 05:29:24 GMT

please use the data type as

"  INT4

reward points if it is usefull ...

Girish

Re: negative value fields

Former Member — Tue, 31 Jul 2007 05:32:26 GMT

you can use this domain

" WERT7

. or else

you can use datatype

" CURR

with sign check box tick .

reward points if it is usefull .....

Girish

Re: negative value fields

Former Member — Tue, 31 Jul 2007 05:56:53 GMT

Does the domain allow for signs?

See the domain of field STUECK, probably it doesn't support the sign -.

You should use a domain can accept the sign +/-

see the domain MENGV8 or MENGV*

Re: negative value fields

Former Member — Tue, 31 Jul 2007 06:05:39 GMT

If you want your table field to accept sign

Then at domain level activate "sign " option

example : check domain "UMS_ANZ"

Re: negative value fields

Former Member — Tue, 31 Jul 2007 06:51:10 GMT

please use the data type as INT4 and select the check box for SIGN

Re: negative value fields

Former Member — Thu, 06 Sep 2007 23:12:32 GMT

Is there a domain or data element that will display negative numbers in parentheses (123) as opposed to the trailing minus sign 123-?

Re: negative value fields

Former Member — Fri, 07 Sep 2007 07:15:28 GMT

hi,

no u will have to write the code for it .

rgds

Re: negative value fields

Former Member — Fri, 07 Sep 2007 09:57:53 GMT

Hi,

Please refer to the domain <b>'PW_QUAN13'</b> in this sign option is checked for it.You can create a domain in this format and assign it to the data element.

regards

Praba