topic Re: negative amount in Application Development and Automation Discussions

negative amount

Former Member — Fri, 09 Jan 2009 16:37:08 GMT

Hello ,

I get amount from cluster.

How to get sign of amount( BETRG field ) from cluster?

Thanks.

Former Member — Fri, 09 Jan 2009 16:45:05 GMT

Have you declared your field of type BETRG itself...as this domain will have sign along with it then you should be getting the sign..

Former Member — Fri, 09 Jan 2009 16:57:20 GMT

Thanks for reply...

But how can I separate amount from sign.

eg amount may be -1234.99 or 1234.99-

Thanks.

Former Member — Fri, 09 Jan 2009 18:45:57 GMT

Try with number2 = abs ( number1 ).

Former Member — Sat, 10 Jan 2009 10:47:26 GMT

IF wa_betrg < 0.

wa_betrg = wa_betrg * (-1). " and u know the number is negative

ENDIF.

Former Member — Wed, 21 Jan 2009 08:53:46 GMT

Hello,

data in field is xx,yy.zz. having length 8.

want to convert it to fix length with adding 00 ie it should be 00xxyyzz without , & .

how to do that.

Thanks.

SuhaSaha — Wed, 21 Jan 2009 09:00:30 GMT

Hello,

You want to remove the decimals seprator as well.

I mean if you have value as 12,345.67, output you want as 001234567.

Plz revert.

BR,

Suhas