Skip to Content
0
Former Member
May 14, 2008 at 12:30 PM

Rolling Up Percentage Values in Web Query

22 Views

Hello ;

I have problem about rolling up values in web query. First, I created a query in Bex Analyzer . Then I selected for results rows of B column like this : in Calculation tab -> Local Calculation -> Calculate Result As -> Moving Avarage. ( and Number of Decimal Places are 0,00 )

After that, I run the query in Bex Analyzer , the result of the report as below :

A B

x 10,02 %

y 20,03 %

z 30,07 %

Result 20,04 % [ ( 30,07 + 20,03 + 10,02 ) /3 ]

My problem is ; when I run this report in web I can not see Decimal Places of Result rows. in web, report like below :

A B

x 10,02 %

y 20,03 %

z 30,07 %

Result 20 %

Result value is : 20 % But it should be 20,04 %

Do you have any idea about it , What can I do ?

Thanks and regards,

Blue