topic Re: decimal value problem in Application Development and Automation Discussions

decimal value problem

Former Member — Mon, 28 Jan 2013 05:47:04 GMT

hi Experts,

I have created the alv grid report to display the balance periodic wise.

the report is displaying fine but the amount value in the report is not displaying the decimal value correctly .

for EX: i have the previous balance 1,455,932.41- and this month balance 8,075,892.48 then the cum.balance should be 6,619,960.07 but it is displaying 6,619960.48 and when we add to next month value 186 it is displaying 6,620,146.00.

the data type i have used is 'CURR'.

please suggest me what to do and what is the reason behind this problem .

thanks

Shambuling

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 05:57:43 GMT

Hi,

Check wether your Adding Values Data type and Destination variable data type same or not.

Thanks

Mani

Re: decimal value problem

vinoth_aruldass — Mon, 28 Jan 2013 06:02:23 GMT

hi,

for currencies its always better to use packed decimals,

the problem occured because while calculating your decimal value is changing . so use standard decimal 2 or three in both the values.

hope it helps,

Vinoth

Re: decimal value problem

yogendra_bhaskar — Mon, 28 Jan 2013 06:03:40 GMT

Hi Shambuling ,

Can you be more specific how you are declaring and calculating the balance .

if you can provide the code , it will be more helpful to solve the issue

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 06:13:19 GMT

hi nagamani

thanku for reply

i am storing the field val\ amount of that month in to the variable bal which is of type i,

is because of it its is displaying link that.

Re: decimal value problem

former_member491621 — Mon, 28 Jan 2013 06:15:22 GMT

Hi Shambuling,

Instead of using type i, try declaring the variable like

data bal type p decimals 3.

This will solve your problem.

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 06:16:30 GMT

hi yogendra

thank you for reply .

i have stored the previous month amount in the variable when the loop is executed the field value is added with the previous balance and displayed .

ex fldval = bal + fldval1.

regards

Shambuling

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 06:20:06 GMT

hi Aniket

Thank you very much that solved the issue. the report is fine now .

regards

Shambuling

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 06:20:52 GMT

hi vinoth

thanks it solved the issue

Re: decimal value problem

Former Member — Mon, 28 Jan 2013 06:21:36 GMT

thank you yogendra for helping