Key figure division using formula

[Former Member]

Dear all,

I have two key figures (KF1,KF2) and I use BEx formula in query by dividing KF2 into KF1 (KF1 / KF2) to get result. I found something strange. If KF1 = 100,000,000, KF2=35.333, the result should be 2830215.379 (rounding to decimal 3). But I found the query result is 2830188.680. It seems like BEx divide 100,000,000 by 35.33333333. I tried to put constant (35.333) instead of KF2 in the formula and the result is correct. Can someone help me out with this problem? Thanks a lot.

[Former Member]

hi,

in BEx,

right click on the KF2 select properties

ther in Number format u can set the decimal value to 3 digits only.

now check the result.

Regards,

Dhanya

[Former Member]

Hi Dhanya,

I did set decimal value to 3 digits for KF2 in the properties.

[Former Member]

Hi,

In ket figure definition--> "additional properties" tab,

check if the checkbox "Key figure with maximum accuracy" is selected.

If so, uncheck that option.

<b>Key figure with maximum accuracy:</b>

If you choose this indicator, then the OLAP processor calculates internally with packed numbers that have 31 decimal places. In doing so, a greater accuracy is attained, and the rounding differences are reduced. Normally, the OLAP processor calculates with floating point numbers.

Hope this helps..

Shylaja.

[Former Member]

Hi,Shylaja

I checked both key figures and the maximum accuracy option are uncheked.

[former_member188325]

what is exact value of KF2? set decimal places to 7/8 and check it out..

Message was edited by: Murali

[Former Member]

Hi Murali,

KF2 = 35.333 (exactly 3 decimal digits)

[Former Member]

By the way, I just found if I add 0 to KF2, it becomes 35.333333333

[former_member188325]

Hi eric,

Since you have set decimal places to 3 it shows 35.333

Set decimal places to 8 and execute the report..It shows exact value of KF2.

[Former Member]

Hi Murali,

It is 35.33300000.