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