COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ratnalein on 08 Nov 2013 08:04:53 AM

Title: Wierd division from report studio
Post by: ratnalein on 08 Nov 2013 08:04:53 AM
Hallo everyone,

I wanted to B / A = Result

Report Studio gave me these wierd results:

A                     B                        Result
-----------------------------------------------
3.831              11.493                     3
   868                2.604                     3
   256                   402                0,140625

So, the first 2 rows are divided correctly, but the 3rd one is wierd.  What have I dont false?  Someone had similar experience?

Thank you..

Regards,

Ratna
Title: Re: Wierd division from report studio
Post by: blom0344 on 09 Nov 2013 09:24:05 AM
1. check tabular data
2. disable auto-aggregation and check the results on row-level

If the first 2 result are both coming from 1 input record, then the displayed result is to be always expected. With multiple incoming rows, you may get phoney result as the division is done prior to the aggregation