If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Wierd division from report studio

Started by ratnalein, 08 Nov 2013 08:04:53 AM

Previous topic - Next topic

ratnalein

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

blom0344

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