topic Re: Replace '0.00' with Blank in Application Development and Automation Discussions

Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 20:50:28 GMT

Hi,

In my Smartform Output requirment If amount is Initial I need to Show a Blank .

My variable is XVAR(6) Type P decimals 2.

How do we do that?

Regards

Vara

Re: Replace '0.00' with Blank

abdul_hakim — Wed, 14 Jun 2006 20:54:36 GMT

the initial value of numeric field is 0 and character field is space.

so if you want space then do the below change.

data:xvar(6) type p decimals 2,

char(6) type c.

move xvar to char.

Cheers,

Abdul Hakim

Mark useful answers..

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 20:59:27 GMT

Hi Vara,

Pls have a look at the code :

data : XVAR(6) Type P decimals 2.

constants : c_blank(1) type c value ' '.

if xvar is initial.

write : c_blank.

else.

write : xvar.

endif.

Hope this will give you an idea.

Cheers,

Vikram

pls reward for helpful replies!!

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:05:23 GMT

hi vara,

data: v_blank type c value ''.

if xvar is initial.

write v_blank.

endif.

award if helpful.

regards,

keerthi.

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:12:21 GMT

Hi All,

Thank you for your answers.

My Target field (X_VAR) is of TYPE P DECIMALS 2.

I need to repalce with a Blank in to this when value is '0.00'.

Regards

Vara

Re: Replace '0.00' with Blank

abdul_hakim — Wed, 14 Jun 2006 21:18:08 GMT

you cannot assign a blank value to numeric datatype field so follow the method which i have described above..

Cheers,

Abdul Hakim

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:18:17 GMT

hi Vara,

data v_char value ' '.

do this way ...

<b> if x_var = '0.00'.

x_var = v_char.

endif.</b>

Regards,

Santosh

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:18:36 GMT

Hi,

when you define a field of type P decimals 2, it will take an default value of '0.00'.

Why cant you use the code that i have mentioned above?

Cheers,

Vikram

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:30:28 GMT

Hi All,

I worked with all of your recommendations.

Still the default value is '0.00'.

I am unable to replace it.

Kindly If possible send me an example where it replaces.

Regards

Prasad

Re: Replace '0.00' with Blank

abdul_hakim — Wed, 14 Jun 2006 21:32:02 GMT

<b>data:xvar(6) type p decimals 2,

char(6) type c.

move xvar to char.</b>

and use char for your display..

Cheers,

Abdul Hakim

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:35:31 GMT

Abdul,

It still display 0.00.

data:xvar(6) type p decimals 2,

char(6) type c.

move char to xvar.

write :/10 xvar.

regards

Vara

Re: Replace '0.00' with Blank

suresh_datti — Wed, 14 Jun 2006 21:38:28 GMT

you should output the char & not type p..


data:xvar(6) type p decimals 2,
w_char(6) type c.
move xvar to w_char.

write :/10 xvar,w_char.

Regards,

Suresh datti

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:45:00 GMT

Hi Vara,

Can you try this code and let me know your concern, if any.

data : XVAR(6) Type P decimals 2.

constants : c_blank(1) type c value ' '.

if xvar is initial. "or if xvar = '0.00'

write : c_blank.

else.

write : xvar.

endif.

Cheers,

Vikram

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:52:43 GMT

Try:


DATA: num(13) TYPE p DECIMALS 2,
      char(16).

WRITE num TO char NO-ZERO.

num = '256.44'.

WRITE num TO char NO-ZERO.

Make sure to pass CHAR to the Smartform.

Rob

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:56:16 GMT

All,

I resolved it my self.

Just I kept a Condition while printing in smartform.

XVAR NE '0.00'.

Thank you all for your quick replies.

Regards

Vara

Re: Replace '0.00' with Blank

Former Member — Wed, 14 Jun 2006 21:59:03 GMT

Sorry - my mistake.

Rob

Message was edited by: Rob Burbank

Re: Replace '0.00' with Blank

RichHeilman — Wed, 14 Jun 2006 22:03:20 GMT

Vara, way to think outside the box. Nice Fix. Can you please mark your post as "Solved on my own". This will provide some visibility to others that this post has a solution. Thanks.

Regards,

Rich Heilman

Re: Replace '0.00' with Blank

RichHeilman — Wed, 14 Jun 2006 22:03:44 GMT

duplicate.

Regards,

Rich Heilman

Re: Replace '0.00' with Blank

RichHeilman — Wed, 14 Jun 2006 23:04:44 GMT

Please mark this post as "Solved on my own" as I have not contributed to this post. Please make sure to award points to others if their answers will at least helpful. Thanks.

Regards,

Rich Heilman