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

summary total shows one dollar extra

Started by cognos05, 04 Nov 2014 10:43:28 AM

Previous topic - Next topic

cognos05

Hi,

I have a report with first column Descendants([Current FYTD],1) which gives some months and next column as Total(first data item).

Instead of 1156 it shows 1157
for all rows an additional one dollar is added.

Is this to do with some properties in cross tab .

Thanks,
Nithya

cognos810

Hello Nithya1224,
Looks like rounding issue to me. Can you check the source data ?

-Cognos810

wildtopiwala

Yes, I agree with Cognos810.

Try to format the summary amount to see if it works.

cognos05

Hi All,

Where should the formatting be done

Ex:
TM1 data Source

Jan 2014 Feb 2014  Mar2014        Total
111.4        111.2       111.2           3334

Cognos
Jan 2014   Feb 2014    Mar 2014  Total
111            111             111         334

How to fix this in cognos.

Please suggest where do i need to do the formatting and how .

Thanks,
Nithya