Aggregate and Rollup aggregate

[cognosmanager]

Hi All,

I have a report in which some portion of data taken looks like this:

emp id            name            pay
1234                 XYZ             2000
1234                 XYZ                 0

so two rows are coming up in this report. So in order to have a single row I changed the property of "Pay" for Aggregate: Total, Rollup Aggregate: None.

After doing this one row is coming but the "Pay" column is showing 4000, i.e. is doubling the data.

I have many other emp id with which this function is running fine but not with this.

Please help me out.

[saumil287]

Hi,
Change the Pay to aggrgate only
and try roll up property to ggregate .


If not then look properties of these items in framework manager .
Test the data from FM first.