AFO Report rounding more than 14 digits

[former_member214778]

Hello AFO experts,

I built a AFO query on top of BW report. The BW report has 2 Measures. The datatype and length is 31,6.

However, when ever the values in those measure exceeds 14 didgits, the AFO report is rounding it.

For Example in BW I have some thing like this : 1.374.964.648.877.617.516.071,178405 .

In the AFO report I get something like this : 1,37496464887762000000000

I am not sure where lies the issue.

Regards,

Sai

[gregor_dieckmann]

Hi Mukesh,

this 'issue' exists with every basic data type used to represent numbers because of the fixed number of bits the data type has. Read the documentation about the data types used in Excel to get more information about the topic; you can also find good information on the internet about 'issues' that come with the DOUBLE data type.

Regards,

Gregor