decimal places on the result row is incorrect

[MaggieMa]

Dear Expert,

I met a problem that decimal places on the result row is incorrect.Anyone can help me?

On key figure balance,we do the currencies translation,also we set the key figure should have two decimal places.

We set a fomular to calculate the total result of Account A,B,C.

(Total result = account Aaccount Baccount C).

If we manually sum up the balance of account A,B,C displayed on analyzer,which are rounded to 2 decimal places,the result should be 601.25(100.61200.38300.26),but the actual total result executed by query is 601.24.

In fact we need the result 601.25 instead of 201.24.

I take the example as following:

Account Balance

Account A 100.61

Account B 200.38

Account C 300.26

Total result 601.24

Thank you in advance.

Best Regards,

Maggie

Edited by: Maggie Ma on Sep 25, 2008 9:17 AM

[Former Member]

Set the accuracy in the query to calculate with packed numbers (RSRT - properties)

[MaggieMa]

Hi Simon,

Thank you for your advice,you mean check the "packed number",but it doesnot work for my case.

Regards,

Maggie

[Former Member]

your "problem" is, that BEx is not totalling the "displayed" values but the real values

try a summation on the following in Excel:

100,605

200,375

300,26

then format the cells to show 2 decimal places only

do you see the result changing?

[MaggieMa]

Hi RafB,

Because my report'f format is not fixed,so I cannot do that calculation in exce..

Anyway,thanks.

Regards,

Maggie

[Former Member]

Hi,

Please try to go to formula properties which you have created.

Check here Formula properties-> Calculations> cal single value result.

Thanks,

Ashok

[MaggieMa]

Hi Ashok,

Thank you for your advice.

But there are a lot of selections here,e.g. Maximum,minimum...etc.

Which one should I check here in Formula properties-> Calculations> cal single value result?

Thanks&Regards,

Maggie