topic Re: multiplication problem in Application Development and Automation Discussions

multiplication problem

Former Member — Mon, 15 Oct 2007 11:15:55 GMT

Hello experts..

I am trying this statement in my code, but it is showing error pls help.

vv007 = kbetr * absmg

here absmg is quan (15 , 3 decimals)

kbetr is curr (11, 2 decimals) ie rate

vv007 is curr(15, 2 decimals).

error is input value is greater than screen field ie vv007(table is ce1****).

Re: multiplication problem

Former Member — Mon, 15 Oct 2007 11:21:13 GMT

Hi Shiva,

Try this.

ws_value is curr(15,3 decimals)

absmg is quan (15 , 3 decimals)

kbetr is curr (11, 2 decimals) ie rate

vv007 is curr(15, 2 decimals)

ws_value = abmsg.

vv007 = ws_value * kbetr.

Reward if Useful.

Regards,

Chitra

Message was edited by:

Chitra Parameswaran

Message was edited by:

Chitra Parameswaran

Re: multiplication problem

JozsefSzikszai — Mon, 15 Oct 2007 11:21:16 GMT

hi shiva,

what are the exact values of kbter and absmg?

thanks

Re: multiplication problem

Former Member — Mon, 15 Oct 2007 11:24:07 GMT

change u r absmg to 2 decimals

change u r kbetr and w007 to 3 decimals

then it will work.

Re: multiplication problem

Former Member — Mon, 15 Oct 2007 12:08:26 GMT

hi Shiva,

it's showing error when u Check the code or when u run the program?

if when it's run, U can try Increasing the size of the field "w007".

I think this:

U have one value size 15 ( no decimals ) and outher of size 11.

look this example:

a = '999999999' "(size 9 without decimals)

b = '999999999' "(size 9 without decimals)

c = a * b.

*c has the value "999999998000000001" and size 18 (more than 15).

maybe this is the error...

try to increaser the size of field of the screen(Paint) and Increase the size of field...

Post urs results plx.

Regards

Allan Cristian

Re: multiplication problem

former_member194797 — Mon, 15 Oct 2007 13:14:08 GMT

Don't forget to choose 'Fixed point arithmetic' in the attributes of your report.