Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: ratnalein on 11 Jun 2013 06:58:06 AM

Title: Formatting pattern integer numbers
Post by: ratnalein on 11 Jun 2013 06:58:06 AM
Hallo everyone,

I have a query item in my query subject.  This query item is an attribute from type Int32.  In Query Studio, this query item appears:

Number of population
---------------------------
3948573
84930900
4940
43
83980
....

Is there any possibilities to format the pattern to be:

Number of population
---------------------------
3.948 573
84.930.900
4.940
43
83.980
....

Thank you for your help.

Regards,

Ratna

Title: Re: Formatting pattern integer numbers
Post by: blom0344 on 11 Jun 2013 08:44:44 AM
Use the 'thousands seperator' by setting this to 'yes'.
Title: Re: Formatting pattern integer numbers
Post by: ratnalein on 11 Jun 2013 10:48:11 AM
Hallo blom0344,

thank you very much, it works ;)

Mhh.. maybe one more question.  As I described before, this is a query item, which is an Attribute.  I have set the Regular Aggregate as Count, which is correct.

I would like to have it summed at the end of the line:

Number of Population
---------------------------
1.000
34.699.500
22
23.843
----------------
34.724.365

Is this possible?  As I said, the regular aggregate of this query item is COUNT.

Thank you for your help.

Regards,

Ratna
Title: Re: Formatting pattern integer numbers
Post by: blom0344 on 11 Jun 2013 11:31:20 AM
Any reason why you would want to 'count' the 'number of population' ?  I guess you could use a  total([number of population] for report) and use that is summary, but I may be missing your point..
Title: Re: Formatting pattern integer numbers
Post by: ratnalein on 11 Jun 2013 02:34:31 PM
Hallo blom0344,

thank you for your quick reply.  In report, I think that would be a good idea to use total.  Actually I was meaning this sum aggregation for Query Studio:

Number of Population with house (this is my fact)            Number of population
---------------------------------------------------------------------------------------------------
2000                                                                                  3000
5000                                                                                  6000
1000                                                                                  2000
---------------------------------------------------------------------------------------------------
8000                                                                                 

The aggregation of my fact column is automatically done from framework manager.  But the number of population is a query item, which is definied as COUNT in the regular aggregation.  In fact, it is a ATTRIBUTE in the physical table.  It would be nice, if I can total this column.  But I think, this is not possible in Query Studio?

Number of Population with house (this is my fact)            Number of population
---------------------------------------------------------------------------------------------------
2000                                                                                  3000
5000                                                                                  6000
1000                                                                                  2000
---------------------------------------------------------------------------------------------------
8000                                                                                 11000

Thank you for your help.

Regards,

Ratna
   
Title: Re: Formatting pattern integer numbers
Post by: blom0344 on 12 Jun 2013 02:57:33 PM
I'm no QS expert, but I fail to see how you could apply a custom aggregate on an attribute the way you want..
Text only | Text with Images