Skip to Content
0
Sep 25, 2008 at 07:16 AM

decimal places on the result row is incorrect

38 Views

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