COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: benmor on 23 Apr 2012 06:07:46 AM

Title: Numbers differs from Framework manager
Post by: benmor on 23 Apr 2012 06:07:46 AM
In Framework Manager I have a field (Int32) that shows the right numbers, but when I look at this field in Query Studio (or Report Studio) it has converted to another value.
For example FWM shows 0.945 which is correct, but Query Studio shows 12.285. What is the reason for this? Do I have to change datatype in Framework Manager?
Title: Re: Numbers differs from Framework manager
Post by: HalfBloodPrince on 23 Apr 2012 06:24:38 AM
Go to query  set Auto Group & Summarize property to  NO and Check.
Title: Re: Numbers differs from Framework manager
Post by: benmor on 23 Apr 2012 06:35:47 AM
Thanks! Works just fine...