CX_SY_ARITHMETIC_OVERFLOW

[Former Member]

Dear all

Can you please assist me. I have a report whereiIm looping internal table and sum the total, then loop again and get total per client and multiply by 100 as a percentage. so formula is individual total/grand total * 100

i hve declared taltal as type p decimal 10, then individual total type p decimal 10 and the final value total as type p decimal 2. amounts have big values of data billions of dollars. im receiving errors like

1. The result field of type P is too small for the result.

2. The result or a intermediate result has more than 31 decimal places.

Please assists me

Regards

William Mutero

[Former Member]

Dear all

Can you please assist me. I have a report whereiIm looping internal table and sum the total, then loop again and get total per client and multiply by 100 as a percentage. so formula is individual total/grand total * 100

i hve declared taltal as type p decimal 10, then individual total type p decimal 10 and the final value total as type p decimal 2. amounts have big values of data billions of dollars. im receiving errors like

1. The result field of type P is too small for the result.

2. The result or a intermediate result has more than 31 decimal places.

Please assists me

Regards

William Mutero

[matt]

Do you need 10 places of decimal accuracy? I find 3 figures is fine for most applications. I use

...TYPE P LENGTH 16 DECIMALS 3.

matt

[Former Member]

Ok let me try that one

Regards

William

[Former Member]

Thanks you so much, thank you thousand times it works fine. You are a star.

Regards

William