COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 04 Nov 2014 10:43:28 AM

Title: summary total shows one dollar extra
Post by: cognos05 on 04 Nov 2014 10:43:28 AM
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
Title: Re: summary total shows one dollar extra
Post by: CognosAnalytics on 04 Nov 2014 06:37:23 PM
Hello Nithya1224,
Looks like rounding issue to me. Can you check the source data ?

-Cognos810
Title: Re: summary total shows one dollar extra
Post by: wildtopiwala on 06 Nov 2014 06:35:32 AM
Yes, I agree with Cognos810.

Try to format the summary amount to see if it works.
Title: Re: summary total shows one dollar extra
Post by: cognos05 on 06 Nov 2014 07:35:41 AM
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